general question on cluster
-
Hi
Does SQLServer stores some data in the system tables about the cluster?? like the member nodes information...I am setting up a cluster and thought that I could ask this question in advance.
thanks
Vijay
-
no. the available nodes for the sqlserver-instance is totaly managed by the cluster-administrator-software.
The sqlserverinstancename is something you cannot change. drop/create is the way for that.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
is there any query that says whether that particular instance is installed on a cluster or not??!!!
-
with sql2000 you can use
select serverproperty('IsClustered') as IsClustered
Books online document serverproperty !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply