--
用代码先删除连接此数据库的进程
declare @d varchar(8000 )
set @d=''
select @d=@d+' kill '+cast(spid as varchar)+char(13 )
from master..sysprocesses where dbid=db_id('库名' )
exec(@d )
-- 然后再删除数据库
declare @d varchar(8000 )
set @d=''
select @d=@d+' kill '+cast(spid as varchar)+char(13 )
from master..sysprocesses where dbid=db_id('库名' )
exec(@d )
-- 然后再删除数据库