How to get IP Address of SQL Server and Client IP Address

Whenever I need to get the IP address of SQL server then I need to execute some script of XP_cmdshell but in some environment I don't have this feature enabled or I need to execute the IPconfig of machine name in commend prompt to find the IP address .Use the attached script to g

 
 
 
 
 
(3)
2,282 times
Add to favorites
Databases
11/28/2012
E-mail Twitter del.icio.us Digg Facebook