get all the users connected to sql server database

Abhinav Tiwari answered on May 10, 2023 Popularity 6/10 Helpfulness 10/10

answer get all the users connected to sql server database

get all the users connected to sql server database

Comment

fire the below command:

SELECT a.*
FROM
(SELECT
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame) a
ORDER BY a.DBName, a.LoginName

And to get number users for specific DB:

SELECT a.*
FROM
(SELECT
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0 and DB_NAME(dbid) ='DB_NAME'
GROUP BY
dbid, loginame) a
ORDER BY a.DBName, a.LoginName

Popularity 6/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: database get sql sql-server

Link to this answer
Share Copy Link

Contributed on May 10 2023

Abhinav Tiwari

0 Answers Avg Quality 2/10

get all the users connected to sql server database

Contents

More Related Answers

get all the users connected to sql server database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.