楼主的方法,在数据库执行是断连接再还原,这样没问题,当前连接是断不了的可以尝试一下用以下方法Kill--在執行前加入 declare @DBName,@Sql nvarchar(4000) set @DBName='Test' set @Sql=char(13)+char(10) select @Sql=@Sql+char(13)+char(10)+' Kill '+rtrim(spid)+';' from sysprocesses where dbid =db_id(@DBName) AND spid=@@SPID exec (@Sql)
http://www.android100.org/html/201406/17/26876.html出现啥问题再贴上来
declare @DBName,@Sql nvarchar(4000)
set @DBName='Test'
set @Sql=char(13)+char(10)
select
@Sql=@Sql+char(13)+char(10)+' Kill '+rtrim(spid)+';'
from sysprocesses where dbid =db_id(@DBName) AND spid=@@SPID
exec (@Sql)