Friday, March 9, 2012

Drop database problem

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