belle’s sql musings

Troubleshooting Database Mail

Posted in Issues/Troubleshooting by belle on September 25, 2008

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:

  1. Enable TCP/IP
    • Start > SQL Server Surface Area Configuration > Surface Area Configuration for Services and Connections
  2. Enable Mail Profile
    • Right click on SQL Server Agent > Properties > Alert System > Enable Mail  Profile
  3. Restart SQL Server Agent
Advertisements
Tagged with:

Issue: Length of LOB data to be replicated exceeds configured maximum 65536

Posted in Issues/Troubleshooting by belle on September 22, 2008

Error:

Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Scenario:

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

Solution:

Increase the size that can be replicated. This is applicable for transactional replication only.

T-SQL: 
EXEC sp_configure ‘max text repl size’, 2147483647

SSMS (excerpt from BOL):

    1. In Object Explorer, right-click a server and select Properties.
    2. Click the Advanced node.
    3. Under Miscellaneous, change the Max Text Replication Size option to the desired value.

Reference:

BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3056cf64-621d-4996-9162-3913f6bc6d5b.htm

Tagged with:

Free SQL Server Video Training + Podcasts

Posted in DBA Toolbox / T-SQL Scripts, Resources/References, Tutorials by belle on September 20, 2008
Tagged with:

MCITP – SQL Server DBA/Developer!

Posted in musings by belle on September 5, 2008

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 …

Tagged with: