I've got 2 SQL 2000 servers within my company, and I've recently
changed some transaction replication objects on a SQL 2000
installation, but I now getting:
Error Code:
7137
MessageUPDATETEXT is not allowed because the column is being processed
by a concurrent snapshot and is being replicated to a non-SQL Server
Subscriber or Published in a publication allowing Data Transformation
Services (DTS).
This only happens on the subscriber when I try to insert data into the
publisher. Any ideas why this is happening? More importantly - how do I
fix it?
Thanks in advanceI deleted all the replication objects, rebooted the servers, and then
re-created them - problem was solved!
pinhead wrote:
> I've got 2 SQL 2000 servers within my company, and I've recently
> changed some transaction replication objects on a SQL 2000
> installation, but I now getting:
> Error Code:
> 7137
> MessageUPDATETEXT is not allowed because the column is being processed
> by a concurrent snapshot and is being replicated to a non-SQL Server
> Subscriber or Published in a publication allowing Data Transformation
> Services (DTS).
> This only happens on the subscriber when I try to insert data into the
> publisher. Any ideas why this is happening? More importantly - how do I
> fix it?
> Thanks in advance
Tuesday, March 20, 2012
Replication problem
Labels:
company,
database,
installation,
microsoft,
mysql,
objects,
oracle,
replication,
server,
servers,
sql,
transaction
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment