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.

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.

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'