Monday, March 12, 2012

Removing Replication MSSQL 2000

Hi Guys, I have recently removed replication from the SQL server (2k)
and everything seemed to be working at first. Initially, the database
still contained all the conflict tables etc... but I got rid of all
those. However, now, when attempting to insert into some tables in the
database, they are failing without errors. If I re-enable replication
for the database the inserts and updates work fine. Anyone ever heard
of this? Any help or suggestions would be appreciated. Thanks!
Regards,
Troy
Troy,
please try running sp_removedbreplication and also take a look at the
tables - do they have any remaining triggers?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment