Home Forums SQL Server 7,2000 T-SQL Retriving host IP Address via T-SQL RE: Retriving host IP Address via T-SQL
Max-146500
SSCarpal Tunnel
Points: 4691
More actions
December 9, 2004 at 5:32 am
#533169
Nice one Frank
I was using xp_cmdshell 'ipconfig' (which is a bit faster) to check the general ip settings but 'ping ' + HOST_NAME() is perhaps easier to hack.
Max