Here we will discuss to find out how many users are connected to our SSMS database using SQL Server.
Below is the query to find out the number of users is a connection to the SQL server.
This query works above SQL server 2005 version
SELECT conn.client_net_address,
SE.host_name,
SE.login_name,
ST.text
FROM sys.dm_exec_sessions SE
INNER JOIN sys.dm_exec_connections conn
ON SE.session_id = conn.session_id
CROSS APPLY sys.dm_exec_sql_text(conn.most_recent_sql_handle) ST
WHERE SE.program_name LIKE 'Microsoft SQL Server Management Studio%'
ORDER BY SE.program_name,
conn.client_net_address;
EmoticonEmoticon