Return to Snippet

Revision: 25605
at April 2, 2010 04:54 by tvanzele


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

Initial URL

                                

Initial Description

                                

Initial Title
Get current users and # sessions

Initial Tags
sql

Initial Language
SQL