Wednesday, 21 January 2009

Length of LOB data to be replicated exceeds configured maximum 65536.

This week I came across the following error :
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 :
  1. Right Click a server in Object Explorer and click Properties
  2. Select Advanced
  3. 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

1 comment: