Have you tried sp_who?

Greg Murrell PC/LAN Engineer-MCP
Wells Fargo Services Company
Desk 208 393 4574
Mobile 208 866 2551
Email greg.[Email Address Removed]


-----Original Message-----
From: Sultana, Naheed [mailto:naheed.[Email Address Removed]
Sent: Thursday, October 31, 2002 8: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