SELECT 'kill '+ CAST(spid as nvarchar(10)) FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
)
想干掉进程,直接执行kill 号码就行。
SELECT 'kill '+ CAST(spid as nvarchar(10)) FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
)
想干掉进程,直接执行kill 号码就行。
转载于:https://my.oschina.net/u/3389832/blog/3094276