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

来源:这里教程网 时间:2026-03-02 10:33:09 作者:

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

相关推荐