Hi All,
I use SQL SERVER 2005 and SQL SERVER Mobile.
My SQL Server I created publication, and on mobile subscriber and did web Synchronization , no problem.
I deleted publication from under Local Publication with SQL SERVER Managment Studio.
and now I want drop database, I get this error "Drop failed for Database DBNAME ... Cannot drop database DBNAME because it is being using Replication"
How to I drop this database ?
And where registred this replication information ?
Regards,
Mahir Quluzade
I executed this script and droped database.
use master
go
exec sp_removedbreplication 'DBNAME'
I found solution my problem.
I use this book : "Pro SQL Server 2005 Replication"
Regards
Mahir Quluzade
No comments:
Post a Comment