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