输入banner图图片脚本导航/分类

SQLServer 断开指定会话

方法1:

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID]
IN
(
SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
WHERE
NAME=‘OIW21017‘
)

方法2:

select * from [Master].[dbo].[SYSPROCESSES] where dbid = db_id(‘OIW12858‘) 

断开会话:

语法:kill spid号

kill 82

SQLServer 断开指定会话

标签:pid   kill   database   sql   roc   sda   _id   proc   开会