sqlserver删除数据库时提示"数据库正在被占用，无法删除"，如何解决，强制删除

执行以下脚本：

USE master;
GO

DECLARE @dbname sysname;	
SET @dbname = 'TingbugDatabase';--这个是要删除的数据库库名

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 = 0
    BEGIN
        EXEC(@s);
        FETCH NEXT FROM tb INTO @s;
    END;
CLOSE tb;
DEALLOCATE tb;
EXEC('drop database ['+@dbname+']');

 

Ending~