How to identify the cluster node using a SQL command ?

• DG 9336

  SSC Enthusiast

  Points: 149

  More actions

  March 12, 2010 at 4:20 am

  #386489

  We have a SQL Server 2008 setup using failover clustering .

  I wanted to identify which machine the SQL Server instance is actually running on, using a SQL command, is there any way of doing this ?

  I was hoping to use something like a server property e.g.

  SELECT SERVERPROPERTY('MachineName'), however these all seem to return the virtual SQL Server name, rather than the underlying machine it is running on.

  Thanks,

  D

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 12, 2010 at 6:33 am

  #1132624

  Try this:

  SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

  -- Gianluca Sartori