如何在 SQL Server 2008 中从 IP 地址获取计算机名称？

我必须从 SQL Server 中的 IP 地址获取计算机名称，我可以做些什么来完成我的任务

DB:

IPAdd | MachineName

Query:

select MachineName from DBTable where IPAdd='yourIPAddress'

尝试使用：

SELECT SERVERPROPERTY('MachineName')

Or

SELECT  
   CONNECTIONPROPERTY('net_transport') AS net_transport,
   CONNECTIONPROPERTY('protocol_type') AS protocol_type,
   CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,
   CONNECTIONPROPERTY('local_net_address') AS local_net_address,
   CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,
   CONNECTIONPROPERTY('client_net_address') AS client_net_address 

Or

SELECT @@SERVERNAME;

Refer:

http://msdn.microsoft.com/en-us/library/ms187944.aspx

希望它有帮助。