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.8 Star
2,514 times
Add to favorites
E-mail Twitter Digg Facebook