How Can I Get Client User Ip Number

Hi,
Use Mssql,
How can I,
Get Client User Ip Number in Mssql
Thanks,I don't know of a direct way to do this is TSQL.
There is a workaround, in your ADO connection string set the workstation id
= 123.123.13.233
Then in TSQL you can retreive this with SELECT HOST_NAME()
HTH. Ryan
"kimsin_sen" <kimsinsen@.hotmail.com> wrote in message
news:%23UYiMISEGHA.1264@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Use Mssql,
> How can I,
> Get Client User Ip Number in Mssql
> Thanks,
>|||I Can Try This Code
In Sql Query Analyzer
SELECT HOST_NAME()
Return Machine Name
No Ip Number
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:e1oolNSEGHA.2728@.TK2MSFTNGP14.phx.gbl...
I don't know of a direct way to do this is TSQL.
There is a workaround, in your ADO connection string set the workstation id
= 123.123.13.233
Then in TSQL you can retreive this with SELECT HOST_NAME()
HTH. Ryan
"kimsin_sen" <kimsinsen@.hotmail.com> wrote in message
news:%23UYiMISEGHA.1264@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Use Mssql,
> How can I,
> Get Client User Ip Number in Mssql
> Thanks,
>|||Did you try changing the ADO connection string on the client 1st or is this
not an option.?
HTH. Ryan
"kimsin_sen" <kimsinsen@.hotmail.com> wrote in message
news:uDEX5USEGHA.1508@.TK2MSFTNGP15.phx.gbl...
>I Can Try This Code
> In Sql Query Analyzer
> SELECT HOST_NAME()
> Return Machine Name
> No Ip Number
>
> "Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:e1oolNSEGHA.2728@.TK2MSFTNGP14.phx.gbl...
> I don't know of a direct way to do this is TSQL.
> There is a workaround, in your ADO connection string set the workstation
> id
> = 123.123.13.233
> Then in TSQL you can retreive this with SELECT HOST_NAME()
> --
> HTH. Ryan
>
> "kimsin_sen" <kimsinsen@.hotmail.com> wrote in message
> news:%23UYiMISEGHA.1264@.TK2MSFTNGP09.phx.gbl...
>
>