Number of connections

Hi Gurus,
Is there any way which I can know the number of connections to SQL Server
2000?
Thanks.
Best regards,
LurcUse the sp_who and sp_who2 system procedures.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"lurc" <lurchot@.hotmail.com> wrote in message
news:%230wXk2ixEHA.3668@.tk2msftngp13.phx.gbl...
> Hi Gurus,
> Is there any way which I can know the number of connections to SQL Server
> 2000?
> Thanks.
> --
> Best regards,
> Lurc
>|||Thanks.
A further question: is it possible to detect the ip address that attached to
a given SQL Server 2000?
Best regards,
Lurc
"lurc" <lurchot@.hotmail.com> wrote in message
news:%230wXk2ixEHA.3668@.tk2msftngp13.phx.gbl...
> Hi Gurus,
> Is there any way which I can know the number of connections to SQL Server
> 2000?
> Thanks.
> --
> Best regards,
> Lurc
>|||Hi lurc,
"lurc" <lurchot@.hotmail.com> wrote in message
news:OP9JkGjxEHA.2016@.TK2MSFTNGP15.phx.gbl...
> Thanks.
> A further question: is it possible to detect the ip address that attached
> to
> a given SQL Server 2000?
If your clients are connected from a web application: get the ip address
from the Server Variables in asp / asp.net
Otherwise you can ping the hostname of client via xp_cmdshell and parse the
output.
Personally I retrieve info from client with:
select USER_NAME() + ', SysUser:' + SYSTEM_USER
+ ', App:' + APP_NAME() + ', Machine:' + HOST_NAME()
+ ' @. ' + cast(getdate() as varchar(20))
as myInfo
HTH,
Andrea