SQLServer删除数据库

删除时提示:

网上找了一段:

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

 

posted @ 2018-01-04 10:30  大侠的哥哥是菜鸟  阅读(889)  评论(0)    收藏  举报