dbTalk Databases Forums  

Find active node name in SQL 2000 Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Find active node name in SQL 2000 Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
v_2ankp
 
Posts: n/a

Default Find active node name in SQL 2000 Cluster - 12-23-2009 , 11:57 PM






I have an application that connects to SQL Server clustered instance and
works based on the fact whether it is installed on active SQL node or passive
SQL node.

I have found fn_virtualservernodes() function that returns the list of
failover nodes. I have observed that the first node returned by this
function's resultset is active node. But this is not documented.
Is this assumption right?
Can you point me to any documentation that ascertains this beahvior?

Also is there any other method through which my application can ascertain if
it is running on active node.

TIA

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.