Does SP_WHO give you what you need?

- BILL -

-----Original Message-----
From: The Oracle Man [mailto:[Email Address Removed] Wednesday, July 10, 2002 12:11 PM
To: [Email Address Removed] Who is logged in?


Hi all. I'm running MSSQL 2000 and wonder how I find
out who is logged into the database at a given time
and get a count of the currently active connections. I
looked thru the documentation and didn't find what
table this information is kept in or how to find this
out. If anyone has a script that would be good OR if
you can just tell me where to find the information I
can write the script. Maybe there is a stored
procedure???

Thanks in advance for any help and
hope you have a good day/night.

Keith

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page