Thanks to all who replied, this is exactly what I
needed; and I see the sysprocesses table gives me all
needed info also from which to start.

KW.
--- "Maskevich, Tony" <Tony.[Email Address Removed] Run Select Count(*) from sysprocesses this will give
> you the raw number of
> current proceeses
>
> -----Original Message-----
> From: The Oracle Man [mailto:[Email Address Removed] Sent: Wednesday, July 10, 2002 1:33 PM
> To: Bill King; [Email Address Removed] Subject: RE: Who is logged in?
>
>
> 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
>
>
---------------------------------------------------------------------
> 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