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

USE MASTER  
GO 
  
DECLARE @dbname SYSNAME 
SET @dbname = 'EducationManagementSystem' -- 这个是要删除的数据库库名
  
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   table[' + @dbname + ']')