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
MS Sql Server LazyDBA home page