IP address from a DB server.

Wilker

Delphi Developer

IP address from a DB server.

2003-12-06 01:04:11 AM
delphi240
Hi All.
using select @@servername I can get the windows server name.
but I need the IP address from this DB server. How can I get this
information ??
I tried :
sp_server_info
sp_serveroption
but does´t return IP address.
thanks.
Wilker.

Oscar Santiesteban Jr.

Delphi Developer

2003-12-08 12:54:01 AM

Re:IP address from a DB server.

Do know if this is possible but I'd try an
xp_cmdshell with a PING command inside of a batch file with the output
redirected to a file. Then OPEN the file and read the response back???
Oscar....
"Wilker" <XXXX@XXXXX.COM>writes

Quote

Hi All.

using select @@servername I can get the windows server name.

but I need the IP address from this DB server. How can I get this
information ??

I tried :
sp_server_info
sp_serveroption

but does´t return IP address.

thanks.

Wilker.