No, sp_who nor sp_who2 works. I guess I need a script
OR to know where that information is kept by the
system so that I can write a script. What I need is
some way for the app. analyst to find out say at 4pm
on July 10, how many users are logged into the
application database and if possible, who they are.
Who they are is not as important as a simple count.

Thanks;

KW.
--- Bill King <[Email Address Removed] wrote:
> Does SP_WHO give you what you need?
>
> - BILL -
>
> -----Original Message-----
> From: The Oracle Man [mailto:[Email Address Removed] Sent: Wednesday, July 10, 2002 12: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]
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
MS Sql Server LazyDBA home page