"The database could not be deleted because the database is currently in use" Problem resolution

Original: "Unable to delete database because the database is currently in use" Problem resolution

Exception handling Rollup-database family http://www.cnblogs.com/dunitian/p/4522990.html

In the past when the database was more distressed this problem, today deleted time and saw, just together record:

Graphical method:

Command-line methods:

Use master    go        declare @dbname sysname    set @dbname = ' bigvaluestest '-this is the name of the database library to be deleted         declare @s nvarchar (    declare TB cursor Local for      select s = ' kill   ' + cast (spid as varchar)   from master.dbo.sysprocesses      where  dbid = db_id (@dbname)         open   TB      fetch   next   from   TB   into   @s when    @ @fetch_status = 0  begin      Exec (@s)       fetch NEXT from TB to @s  End    Close   TB    deallocate   TB      exec (' Drop   database   [' + @dbname + '] ')   

This principle is similar to the operating system inside the PID Kill program

"The database could not be deleted because the database is currently in use" Problem resolution