Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Find active node name in SQL 2000 Cluster

2 views
Skip to first unread message

v_2ankp

unread,
Dec 24, 2009, 12:57:01 AM12/24/09
to
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

0 new messages