Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Can't delete db thas been part of replication

Author  Topic 

Rauken
Posting Yak Master

108 Posts

Posted - 2007-02-07 : 05:24:30
I setup replication (merge) for a test db with 11 tables. Deleted the publication and want to delete the database itself. Sql server says it can't be deleted becuase it's has replication setup! Bug??

Rauken
Posting Yak Master

108 Posts

Posted - 2007-02-07 : 07:30:01
Found the answer, have to run a little t-sql to get all replication objects to be removed:
sp_removedbreplication @dbname = 'dbname', @type = 'merge'
Go to Top of Page
   

- Advertisement -