SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2

Following error is very generic error and I have previously written SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.

Msg 3702, Level 16, State 3, Line 2
Cannot drop database “DataBaseName” because it is currently in use.

One of the reader Dave have posted additional information in comments. I will list his advise here. First read the original post here.

If you are still getting the error after you try using
USE master
GO
DROP DATABASE (databaseName)
GO

Close SQL Server Management Studio completely. Open it again and connect as normal. Now you will be able to drop the database with
USE master
GO
DROP DATABASE (databaseName)
GO

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

11 thoughts on “SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2

  1. I get

    Msg 5061, Level 16, State 1, Line 1
    ALTER DATABASE failed because a lock could not be placed on database ‘xxx’. Try again later.
    Msg 5069, Level 16, State 1, Line 1
    ALTER DATABASE statement failed.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s