Archive

Archive for April, 2012

cannot drop database because it is currently in use

April 30, 2012 Leave a comment

1) While trying to drop the database dont use the same database name.

USE Master;
GO


DROP DATABASE TestDB;
GO

2) But again you are getting the same error, then completly close SQL Server Management Studio . Open it again and connect. Now try to run the below script

USE Master;
GO


DROP DATABASE TestDB;
GO

3) Still if u get the error, then find sessions of the database that you are trying to drop

EXEC sp_who2
--Run kill SPID for each process that is using the database to be dropped.
kill <SPID> -- Kill 57
Advertisements
Categories: SQL
%d bloggers like this: