Hi,
I want to find out how many users are currently logged into database, How can I do that?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SenthilkumarPosted Feb 24, 2012, 2:31 AM
You can use the following to get the currently logged in users in database.
select count(*) from master..sysprocesses where spid > 50
SELECT SYSTEM_USER - This will give you the currently logged in user in sql query window.