Posted By

tvanzele on 04/02/10

Tagged

Viewed 718 times

Favorited by 1 user(s)

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT login_name, COUNT(session_id) AS [session_count] 
FROM sys.dm_exec_sessions 
GROUP BY login_name
ORDER BY COUNT(session_id) DESC;

Comment:

You need to login to post a comment.