Ads

29 December 2011

Max Replication Text Size


When SQL Server is installed, the Max Replication Size value is set by default to 65536. If a record is inserted into a published table that exceeds that value, an error will occur at the application.
The following error will be returned to the calling application:
__________________________________________________________________________________
    Server: Msg 7139, Level 16, State 1, Line 1
Length of text, ntext, or image data (200) to be replicated exceeds configured maximum 10.
The statement has been terminated
__________________________________________________________________________________
In order to prevent this from occurring, Max Text Replication Size needs to be overridden to the maximum allowed, which is 2147483647

Solution :- 


exec sp_configure 'max text repl size', 2147483647

reconfigure with override


No comments:

Post a Comment