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
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy