Get server name from ip address
Mar 23, 2013 · T-SQL Query to find IP Address of SQL Server Here is a handy T-SQL script to find the IP Address of the SQL Server you are connected to. SELECT CONNECTIONPROPERTY ('local_net_address') AS [IP Address Of SQL Server]