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 2012 Forums
 Transact-SQL (2012)
 Cannot Drop Database Because Used for Replication

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-04-28 : 14:58:47
I have a 2012 instance database that I want to drop. Delete the database, that is.

"Cannot drop database because it is used for replication"

I DID have replication on it but have removed that. Perhaps some remnants are still around but the gui doesn't show anything.

Any ideas? Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-04-28 : 15:00:13
sp_removedbreplication

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-04-28 : 17:11:40
It has been awhile since I worked with replication. (SQL Server 2000)
That worked, Tara.
Thank you!
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-04-28 : 17:11:45
It has been awhile since I worked with replication. (SQL Server 2000)
That worked, Tara.
Thank you!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-04-28 : 17:59:17


Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -