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?
Showing posts with label runningon. Show all posts
Showing posts with label runningon. Show all posts
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 runni
ng
> on from within SQL Server. How can I do that?
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 runni
ng
> on from within SQL Server. How can I do that?
Subscribe to:
Posts (Atom)