Search This Blog

April 24, 2013

Not able to drop sql server database

Error Message:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot drop the database '' because it is being used for replication. (Microsoft SQL Server, Error: 3724)


Resolution:
  Execute the following command then drop the database. 

sp_removedbreplication ''