all groups > sql server replication > june 2006 >
You're in the

sql server replication

group:

sp_configure 'max text repl size'


sp_configure 'max text repl size' Albatross Singh
6/6/2006 2:19:02 PM
sql server replication:
Greetings

I am getting the following error on repliation of a SQL 2000 server:
"Length of text, ntext, or image data (66321) to be replicated exceeds
configured maximum 65536. The statement has been terminated."

Web posts advise the use of sp_configure 'max text repl size'. Is there a
setting I can change in the GUI or do I have to run the procedure? If anyone
has an example of the procedure, I would really appreciate some pointers.

Re: sp_configure 'max text repl size' Hilary Cotter
6/6/2006 7:07:27 PM
I don't believe it is exposed through the gui. Run sp_configure in QA.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Albatross Singh" <AlbatrossSingh@discussions.microsoft.com> wrote in
message news:4174DE69-8573-4257-885F-74ED01B508B9@microsoft.com...
[quoted text, click to view]

RE: sp_configure 'max text repl size' Chris
6/7/2006 12:15:02 PM

example:

-- max size possible
exec sp_configure 'max text repl size', 2147483647

reconfigure with override


Regards,
ChrisB
MyDatabaseAdmin.com


[quoted text, click to view]
AddThis Social Bookmark Button