Groups | Blog | Home
all groups > sql server replication > august 2003 >

sql server replication : removing conflict tables


JOE
8/19/2003 5:01:54 PM
I just disabled replication on my server. The conflict
tables are still in my DB though.

Is there a way to get rid of them? My Access front end
chokes on the amount of tables it links to.

Thanks,
gopal NO[at]SPAM online.microsoft.net
8/20/2003 12:24:51 AM
Hi Joe,
If the replication uninstall did not remove the table then one way to
remove them is to do
Drop table from the query analyzer, since this is a system table you cannot
drop this from enterprise
manager. If there is a large number of these tables you might want to write
a script to drop the table
from the query analyzer.

Again the replication uninstall should have removed these tables.

Thanks
Gopal
JOE
8/20/2003 6:52:22 AM
I will try to reinitialize replication on the DB, and then
disable it once again. Maybe this time it will remove
these tables.

Thanks for the info.
Joe
AddThis Social Bookmark Button