MSSQL查看数据库连接

查看所有连接 exec sp_who

查看指定库的连接 SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE NAME=’specified database name’ )