Current Connections

I am wanting to see how many connections there currently are to my database.
Is there a query that I can run that will tell me this?
I am running SQL 2000 sp3
Thank you in advance.
BrianBrian,
sp_who
--and/or--
sp_who2 active
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brian Whitaker" <bwhitaker@.amerimm.com> wrote in message
news:uqmKKfrVDHA.612@.TK2MSFTNGP10.phx.gbl...
> I am wanting to see how many connections there currently are to my
database.
> Is there a query that I can run that will tell me this?
> I am running SQL 2000 sp3
> Thank you in advance.
> Brian
>|||Thank you very much!!
Brian
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:OCELQorVDHA.2100@.TK2MSFTNGP11.phx.gbl...
> Brian,
> sp_who
> --and/or--
> sp_who2 active
>
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Brian Whitaker" <bwhitaker@.amerimm.com> wrote in message
> news:uqmKKfrVDHA.612@.TK2MSFTNGP10.phx.gbl...
> > I am wanting to see how many connections there currently are to my
> database.
> > Is there a query that I can run that will tell me this?
> >
> > I am running SQL 2000 sp3
> >
> > Thank you in advance.
> >
> > Brian
> >
> >
>