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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

USERS 1

Status
Not open for further replies.
DirtyB

DirtyB

Programmer
Mar 13, 2001
159
US
We are having some licensing issues. How can you tell, at any given time, what users are currently logged into the database?
 
Sort by date Sort by votes
Run the Stored Procedure sp_who (For example from the Query Analyzer). It shows all the current connections to the server.


USE master
EXEC sp_who
 
Upvote 0 Downvote
THANK YOU...I knew there was a proc for it, but I just had never used it...It's much appreciated
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

asmall
  • Locked
  • Question
Users Not Assigned to a Group
Replies
1
Views
170
johnherman
johnherman
PeDa
  • Locked
  • Question
Identfying current users of database
Replies
4
Views
191
PeDa
PeDa
SBTBILL
  • Locked
  • Question
MSSQL says there are other users when there aren't 2
Replies
4
Views
277
gbaughma
gbaughma
DougNaf
  • Locked
  • Question
Domain users connected to SQL database
Replies
2
Views
219
NoCoolHandle
NoCoolHandle
1DMF
  • Locked
  • Question
App won't let users change data, where is the lock
Replies
1
Views
127
1DMF
1DMF

Part and Inventory Search

Sponsor

Back
Top