January 4, 2002 at 12:34 pm
We have just removed merge replication from a database and find that about 10 system tables are left in the database that are only used by merge replication. I tried deleting the tables and can't. I even went to server settings and checked the box to allow modifications to be made directly to the system catalogs.
How can I delete these tables? If I go to sysobjects and delete the tables will that drop them completely or just make so I can't see them anymore.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
January 4, 2002 at 7:53 pm
Tried sp_MSdrop_mergesystables?
Andy
January 7, 2002 at 1:59 pm
execute sp_removedbreplication 'dbname'
Abdu
January 7, 2002 at 2:06 pm
Thanks! I'll remember these for next time, unfortunately the tables seem to have vanished on there own.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply