Obtain machine name from Sql server instance name

does any one know how to get the machine name in the LAN by reading the SQL server instance name installed on it?

You can obtain the machine name using the system function SERVERPROPERTY('MachineName'). Using SMO, you can find the same using Server.Information.NetName .

Thanks,
Kuntal

|||thank u very much. such a nice person|||Hi,
Is it possible to retrieve list of Reporting services server that running on the LAN?