Re: Question on SQL Cluster

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sujas,

If you are on SQL 2005 maybe this is wat you want:

SELECT * FROM sys.dm_os_cluster_nodes
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') ActiveNode

The first one lists all the nodes within the cluster, second one reports the
current active node.

Grtz,
Patric


"shub" <shubtech@xxxxxxxxx> wrote in message news:1190304933.477428.143460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
In a cluster environment for SQL what is the best way to find out the
name of the real physical computer? I know the SQL instances are
virtual and the but I want to find out what real server is it running
on. Is there a way to find out via EM or via T-SQL? I am sure others
have run into this too.

Any help in this regard will be greatly appreciated.

Thanks
Sujas


.