Finding How Many users connected ?

15 Jul 2005 4:49 AM

WhiteJul

if there is any SP to check how many users are connected to my sql server?
This is good in case I need to know who is connected or not, so I can bounce
the server or do some maintenance without interfering with users's
connections.
Thanks

15 Jul 2005 4:55 AM

Uri Dimant

Hi
sp_who 'active'

Show quote

"WhiteJul" <white***@hotmail.com> wrote in message
news:u%23NgxiPiFHA.3540@TK2MSFTNGP14.phx.gbl...
> if there is any SP to check how many users are connected to my sql
server?
> This is good in case I need to know who is connected or not, so I can
bounce
> the server or do some maintenance without interfering with users's
> connections.
> Thanks
>
>

15 Jul 2005 8:50 AM

WhiteJul

isn't this SP similar to going into Enterprise Manager > Management >
Activity? is any difference?

Show quote

"Uri Dimant" <u***@iscar.co.il> wrote in message
news:%23bLvwlPiFHA.3476@TK2MSFTNGP10.phx.gbl...
> Hi
> sp_who 'active'
>
>
>
>
> "WhiteJul" <white***@hotmail.com> wrote in message
> news:u%23NgxiPiFHA.3540@TK2MSFTNGP14.phx.gbl...
>> if there is any SP to check how many users are connected to my sql
> server?
>> This is good in case I need to know who is connected or not, so I can
> bounce
>> the server or do some maintenance without interfering with users's
>> connections.
>> Thanks
>>
>>
>
>