RE: How can we find who is logged on the server

RE: How can we find who is logged on the server

 

  

Thanks All

-----Original Message-----
From: Farnsworth, Dave [mailto:[Email Address Removed]
Sent: Thursday, October 31, 2002 11:09 AM
To: Sultana, Naheed; LazyDBA.com Discussion
Subject: RE: How can we find who is logged on the server

exec sp_who2
or
exec sp_who

-----Original Message-----
From: Sultana, Naheed [mailto:naheed.[Email Address Removed] Thursday, October 31, 2002 9:30 AM
To: LazyDBA.com Discussion
Subject: How can we find who is logged on the server


Hi All



I need help on how to find how many people are using SQL server at a given
time, can we write a script for that.







TIA





MS Sql Server LazyDBA home page