question

Mandar Alawani avatar image
Mandar Alawani asked

"max text repl size" used even after disabling replication

Hi All, Transactional Replication was removed some months back from one of my SQL servers (SQL server 2005). Still I got below error during insert in one of our columns: “Length of LOB data (xxxxxx) to be replicated exceeds configured maximum 65536.". I have checked below and find no entries for replication: --no info in distribution DB --sp_replmonitorhelpsubscription @publisher = NULL, @publication_type = 0 Questions: 1. Is there any other place where I check any remains of replication? 2. Why do I get error about "max text repl size" parameter as I understand this will be used only if Trans repl only (as this is SQL 2005, so CDC cannot be configured) is enabled ( http://msdn.microsoft.com/en-sg/library/ms179573(v=sql.90).aspx) ? any help is highly appreciated!!... thanks
sql-server-2005replicationlob
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
KenJ avatar image
KenJ answered
You might try [sp_removedbreplication][1] Replication bits and pieces can be left behind when removing replication and this sometimes cleans them up. If that doesn't help out, you might try the sp_configure solution in the link you provided (`sp_configure 'max text repl size', 2147483647`). [1]: http://msdn.microsoft.com/en-us/library/ms188734.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.