Tuesday, March 20, 2012

cluster check

Guys,
Apart from cluster administrator, is there any way to check from inside SQL
server to know whether a particular installation is clustered?
select serverproperty('IsClustered') will tell you if a particular instance
is part of a cluster
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:A33FB883-4923-45A0-BAA8-434B5530D971@.microsoft.com...
> Guys,
> Apart from cluster administrator, is there any way to check from inside
> SQL
> server to know whether a particular installation is clustered?
|||thanks jasper...
"Jasper Smith" wrote:

> select serverproperty('IsClustered') will tell you if a particular instance
> is part of a cluster
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Bharath" <Bharath@.discussions.microsoft.com> wrote in message
> news:A33FB883-4923-45A0-BAA8-434B5530D971@.microsoft.com...
>
>

No comments:

Post a Comment