sqlserver ,数据库offline时提示有连接无法释放

Msg 5061, Level 16, State 1, Line 1
ALTER DATABASE failed because a lock could not be placed on database 'SK_WMS_DB'. Try again later.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

select
db_name(dbid) as [Database Name], 
count(dbid) as [No Of Connections],
loginame as [Login Name]
from
sys.sysprocesses
where
dbid > 0
group by
dbid, loginame

set nocount on
declare @databasename varchar(100)
declare @query varchar(max)
set @query = ''
 
set @databasename = 'baktest'
if db_id(@databasename) < 4
begin
    print 'system database connection cannot be killeed'
return
end
 
select @query=coalesce(@query,',' )+'kill '+convert(varchar, spid)+ '; '
from master..sysprocesses where dbid=db_id(@databasename)
 
if len(@query) > 0
begin
print @query
exec(@query)
end

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22193071/viewspace-1096777/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22193071/viewspace-1096777/