解除sql server数据库占用

master go declare @dbName nvarchar(50) set @dbName=‘Supervise_changchun‘ --数据库名 declare @spid nvarchar(20) declare cur_lock cursor for SELECT DISTINCT request_session_id FROM master.sys.dm_tran_locks WHERE resource_type = ‘DATABASE‘ AND resource_database_id = db_id(@dbName) open cur_lock fetch cur_lock into @spid while @@fetch_status=0 begin exec( ‘kill ‘+@spid) fetch Next From cur_lock into @spid end close cur_lock deallocate cur_lock

 

use master

go

declare @dbName nvarchar(50)

set @dbName=‘Supervise_changchun‘ --数据库名

declare @spid nvarchar(20)

declare cur_lock cursor for

SELECT DISTINCT request_session_id FROM master.sys.dm_tran_locks WHERE resource_type = ‘DATABASE‘ AND resource_database_id = db_id(@dbName)

open cur_lock

fetch cur_lock into @spid

while @@fetch_status=0

begin

exec( ‘kill ‘+@spid)

fetch Next From cur_lock into @spid

end

close cur_lock

deallocate cur_lock

解除sql server数据库占用

标签：div   margin   use   占用   weight   size   declare   locate   数据库名