I had replication on a SQL 7 box and then removed it. I think it was not properly removed as while doing an upgrade of an application that uses the database I got a message saying -
[Microsoft][ODBC SQL server Driver][SQL Server] length of text,ntext,image (179948) to be replicated exceeds configured maximum 65536 - 2147217887 Microsoft OLEDB Provider for ODBC Drivers.
I also notice that the sysarticles table has entries in it for the tables in the database.
How may i resolve this problem?
All help appriciated
set max_repl_size to a larger value and try again.
sp_configure 'max text repl size', 200000
"Rohans" <anonymous@.discussions.microsoft.com> wrote in message
news:90B8EDF5-4EA3-4608-B400-591369278080@.microsoft.com...
> I had replication on a SQL 7 box and then removed it. I think it was not
properly removed as while doing an upgrade of an application that uses the
database I got a message saying -
> [Microsoft][ODBC SQL server Driver][SQL Server] length of text,ntext,image
(179948) to be replicated exceeds configured maximum 65536 - 2147217887
Microsoft OLEDB Provider for ODBC Drivers.
> I also notice that the sysarticles table has entries in it for the tables
in the database.
> How may i resolve this problem?
> All help appriciated
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment