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

Who's Connected ??

Status
Not open for further replies.
Uriel365

Uriel365

Programmer
Dec 18, 2001
37
GB
I am quite new to SQL Server programming but have been asked because of licensing issues to find out whether it is possible to see who is currently logged into the database.

Paul
 
Sort by date Sort by votes
Either execute sp_who/sp_who2 stored procs or use the Current Activity window in Enterprise Manager.

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DougNaf
  • Locked
  • Question
Domain users connected to SQL database
Replies
2
Views
54
NoCoolHandle
NoCoolHandle
ik2003
  • Locked
  • Question
find who is connected to my MS SQL Server
Replies
1
Views
27
bborissov
bborissov
swreng
  • Locked
  • Question
CONNECTED USERS
Replies
1
Views
15
SQLDenis
SQLDenis
JAPixley
  • Locked
  • Helpful tip
Who's Locking My Database?
Replies
3
Views
25
jabmod
jabmod
JordanR
  • Locked
  • Question
Can Access web page connected to SQL Server
Replies
7
Views
52
JordanR
JordanR

Part and Inventory Search

Sponsor

Back
Top