REplication of image data (urgent)
Hello everyone,
I'm running merge replication with several databases. So far everything worked fine, but now I tried to insert some new records and I get the message:
Server: Msg 7139, Level 16, State 1, Line 1
Length of text, ntext, or image data (73728) to be replicated exceeds configured maximum 65536.
The statement has been terminated.
Can anybody tell me how if I can change this max. value and how ?
Thanks a lot
Mike B.
REplication of image data (urgent) (reply)
Hi Mike,
you'll hve to change the server configuration option max text repl size using sp_configure.
Markus
------------
Mike at 5/3/2002 10:22:13 AM
Hello everyone,
I'm running merge replication with several databases. So far everything worked fine, but now I tried to insert some new records and I get the message:
Server: Msg 7139, Level 16, State 1, Line 1
Length of text, ntext, or image data (73728) to be replicated exceeds configured maximum 65536.
The statement has been terminated.
Can anybody tell me how if I can change this max. value and how ?
Thanks a lot
Mike B.
Max Size Increased Like this
Declare @NewSize bigint
Set @NewSize = 100000000
print 'Old size'
exec sp_configure 'max text repl size'
print ' Setting new size'
exec sp_configure 'max text repl size', @NewSize
print 'Reconfiguring'
RECONFIGURE WITH OVERRIDE
print 'New size'
exec sp_configure 'max text repl size'