find server name using query

[Sundaram Muthusamy]

how we find the server name using sqlserver2005-Query analyser

[Vidhura]

Use the following query
select @@servername

[siva538]

Use the following query
select @@servername

@@ServerName returns the servername of the sql server and

 select serverproperty('MachineName') 
 

gives the box name in which sql server is running.

[vignessh]

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());
}