--说明库B有连接的进程,用下面语句清除
declare @d varchar(8000)
set @d=''
select @d=@d+' kill '+cast(spid as varchar)+char(13)
from master..sysprocesses where dbid=db_id('B库名')
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('B库名')
exec(@d)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货