find server name using query

how we find the server name using sqlserver2005-Query analyser

re: find server name using query

Use the following query
select @@servername

re: find server name using query

@@ServerName returns the servername of the sql server and

gives the box name in which sql server is running.

re: find server name using query

to find machine name by sql qury : select host_name();
to find machine name and ip addrss by c# :
string hostName = Dns.GetHostName();
listBox1.Items.Add ("Host Name = " + hostName);
//v can also use this
//IPHostEntry local =Dns.GetHostByName(hostName);
IPHostEntry local = Dns.GetHostEntry(hostName);
foreach (IPAddress ipaddress in local.AddressList)
{
listBox1.Items.Add ("IPAddress = " + ipaddress.ToString());
}