If you have configured Database Mail, and SQL Server still isn’t able to send emails out, here are a few things to check/do:
- Enable TCP/IP
Enable Mail Profile
- Start > SQL Server Surface Area Configuration > Surface Area Configuration for Services and Connections
Restart SQL Server Agent
- Right click on SQL Server Agent > Properties > Alert System > Enable Mail Profile
Length of LOB data (78862) to be replicated exceeds configured maximum 65536
We published some articles that use varchar(max) and a lot of XML data types for the columns. When we enabled replication, we got the error Length of LOB data (78862) to be replicated exceeds configured maximum 65536
Increase the size that can be replicated. This is applicable for transactional replication only.
EXEC sp_configure ‘max text repl size’, 2147483647
SSMS (excerpt from BOL):
- In Object Explorer, right-click a server and select Properties.
- Click the Advanced node.
- Under Miscellaneous, change the Max Text Replication Size option to the desired value.
Yay! I finished the four exams required for MCITP DBA and Developer 🙂 I’ll blog about some of my exam mishaps and misadventures later on …