Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOw to check number of users connected

Status
Not open for further replies.
moolie

moolie

Programmer
May 7, 2002
193
CA
How to check the number of users connected to a particular database.
 
Sort by date Sort by votes
Or in enterprise manager under management, select current activity to see who is currently logged into what db and order by database name to group it.

Transcend
[gorgeous]
 
Upvote 0 Downvote
I was aware of TRANSCEND's suggestion about checking the current activity log. In this case the sp_who was a better fit. I needed to be able to check the number of users logged on from within the desktop application I am developing. I queried the db using sp_who and then created a temp table based on that information. Then I can filter the information to get a number of users logged into a specific DB on the server.

Worked very well. Thanks again.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
318
dhookom
dhookom
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
318
dgillz
dgillz
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
320
torquinian
torquinian
dgillz
  • Locked
  • Question
SQL Server timeouts after updating workstations to Windows 10
Replies
0
Views
315
dgillz
dgillz
JoPaBC
  • Locked
  • Question
Schedule and automate backups of SQL Express databases in SQL Server Express 1
Replies
5
Views
469
JoPaBC
JoPaBC

Part and Inventory Search

Sponsor

Back
Top