How to get Client IP Address

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to get Client IP Address

Message

30/03/2005 14:47:52

Jayesh Patel
Infogroup, Inc
Pearl River, New York, États-Unis

30/03/2005 13:45:10

Kirk Kelly
Nextgen Healthcare
Austin, Texas, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: How to get Client IP Address

Divers

Thread ID:

01000024

Message ID:

01000051

Vues:

This message has been marked as a message which has helped to the initial question of the thread.

Not sure any direct way of doing it withing SQL Server.

Try xp_cmdshell 'ping YourHostName'. You will have to parse the returned string to get the IP Address.

>Does SQL Server 2000 have a means to get a connection/client's IP address?
>
>Thanks
>
>Kirk

- Jayesh

Répondre

Fil

Voir

Click here to load this message in the networking platform