Length of LOB data to be replicated exceeds configured maximum 65536
When we where uploading pictures to store in a column of data type "Image" into our SQL server 2005 database.
The error is thrown when replication is enabled on the server, so the fix for this is rather easy ... increase the size that can be replicated using the following T-SQL Statement
sp_configure ‘max text repl size’, 2147483647
Or via the Management Studio :
- Right Click a server in Object Explorer and click Properties
- Select Advanced
- Under the Miscellaneous Category, change the Max Text Replication Size to the value you want.
Max Text Replication Size definition (as defined in the SSMS): Specifies the maximum data that can be added to a replicated column in
a single INSERT, UPDATE , WRITETEXT or UPDATETEXT statement
Thanks for the tip, fixed my problem!
ReplyDelete