断开所有远程连接（sql server）

DECLARE @d VARCHAR(8000)
SET @d = ' '

SELECT
@d = @d + ' kill ' + CAST(spid AS VARCHAR) + CHAR(13)
FROM
MASTER.sys.sysprocesses
WHERE
dbid = DB_ID('ATMS ')

EXEC (@d)