当前位置: 代码迷 >> SQL >> 哪位高手在连接sqlserver
  详细解决方案

哪位高手在连接sqlserver

热度:83   发布时间:2016-05-05 11:07:01.0
谁在连接sqlserver?
--谁在连接sqlserver?SELECT [dec].client_net_address,       [des].[program_name],       [des].[host_name],       Count([dec].session_id) AS connection_countFROM   sys.dm_exec_sessions AS [des]       INNER JOIN sys.dm_exec_connections AS [dec]               ON [des].session_id = [dec].session_idGROUP  BY [dec].client_net_address,          [des].[program_name],          [des].[host_name]ORDER  BY [des].[program_name],          [dec].[client_net_address];
  相关解决方案