sql - 如何从 SQL Server 2008 中的 IP 地址获取机器名称？

Question

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

Answer 1

数据库:

IPAdd | MachineName

查询:

select MachineName from DBTable where IPAdd='yourIPAddress'

试试:

SELECT SERVERPROPERTY('MachineName')

或

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 

或

SELECT @@SERVERNAME;

引用:

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

希望它有帮助。