sql-"无法删除数据库，因为该数据库当前正在使用"问题解决

USE MASTER  GO     DECLARE @dbname SYSNAME  SET @dbname = 'databasename' --这个是要删除的数据库库名     DECLARE @s NVARCHAR(1000)  DECLARE tb CURSOR LOCAL FOR    SELECT s = 'kill   ' + CAST(spid AS VARCHAR)    FROM   MASTER..sysprocesses    WHERE  dbid = DB_ID(@dbname)     OPEN   tb    FETCH   NEXT   FROM   tb   INTO   @s  WHILE @@fetch_status = 0BEGIN    EXEC (@s)     FETCH NEXT FROM tb INTO @sEND  CLOSE   tb  DEALLOCATE   tb  EXEC ('drop   database   [' + @dbname + ']')