关闭数据库中的所有活跃会话
Kill All Active Sessions In Database
发布-日期: 2014年4月9日 (评论)
Contents
中文
我通常把它写在任何我想要运行的数据库还原前面。
English
I usually write this ahead of any database restores I might want to run.
Logic
use master;
set nocount on
declare @my_database_name varchar(255)
declare @kill_all_connections_to_database varchar(max)
set @my_database_name = 'MyDatabaseName'
set @kill_all_connections_to_database = ''
select @kill_all_connections_to_database = @kill_all_connections_to_database
+ 'kill ' + cast(spid as varchar(4)) + '; ' + char(10)
from
sysprocesses
where
db_name(dbid) = @my_database_name
exec (@kill_all_connections_to_database)
go
Build-Info
Build Quality | Build History | ||||
---|---|---|---|---|---|
Author
- 李聪明的数据库 Lee's Clever Data
- Mike的数据库宝典 Mikes Database Collection
- 李聪明的数据库 "Lee Songming"