Try MS's script - sp_who

> -----Original Message-----
> From: The Oracle Man [SMTP:[Email Address Removed] Sent: Wednesday, July 10, 2002 7:11 PM
> To: [Email Address Removed] Subject: 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] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page