SQL SERVER查看当前连接情况
时间：2022-03-13 23:18
使用超级管理员账户登录,并执行以下命令:
SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT [DBID] FROM [Master].[dbo].[SYSDATABASES] WHERE 1=1 ) and substring(cast(login_time as varchar),0,12) = ‘09 2 2014 ‘ order by last_batch,hostname
