Re: sp_configure 'max text repl size'
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Tue, 6 Jun 2006 19:07:27 -0400
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4174DE69-8573-4257-885F-74ED01B508B9@xxxxxxxxxxxxxxxx
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.
Thanks
.
- Prev by Date: Re: Publisher/Distributor crashed
- Next by Date: Re: Can Merge w/ SQL2000 Pub / 2005 Subscr?
- Previous by thread: Publisher/Distributor crashed
- Next by thread: Re: Can Merge w/ SQL2000 Pub / 2005 Subscr?
- Index(es):
Relevant Pages
|
