select * from sys.dm_exec_sessions //查询有多少个会话,会话的全部内容都列出来。
如果只要指定内容,如host_name/program_name/login_time:
select host_name,program_name,login_time from sys.dm_exec_sessions group by host_name,program_name,login_time
如果要查每台电脑连接到SQL Server2008的数目:
select host_name,program_name,login_time,count(*) as sl from sys.dm_exec_sessions group by host_name,program_name,login_time