Wednesday, March 21, 2012

How to determine a physical node name with a sql cluster?

I am trying to determine what physical node my sql server cluster is running
on from within SQL Server. How can I do that?
For example. In query analyzer
select @.@.servername
- returns the virtual name.
Select CONVERT(Varchar(25), SERVERPROPERTY('machinename'))
- returns the virtual name.
"Charles" wrote:

> I am trying to determine what physical node my sql server cluster is running
> on from within SQL Server. How can I do that?

No comments:

Post a Comment