使用超级管理员账户登录,并执行以下命令:
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
原文：http://www.cnblogs.com/onmyway20xx/p/3951805.html