SQL SERVER查看当前连接情况

使用超级管理员账户登录,并执行以下命令:

 

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