active physical node

Is there any way to find out using a sql query or from registry the current
active node (physical server) of a cluster? I do not want to use the cluadmin
gui.
if i can find out the node on which sql resources are active using a query -
it will be helpful.
cheers,
bharath
I remember a tip, probably from Tom, about this. If you keep a text file at
the same location on each of the nodes, and store the name of the node in
those files, then you can connect to the server and run something like below
to get the server name:
EXEC master..xp_cmdshell 'Type C:\NodeName.txt'
GO
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:E2F171C0-4591-48AF-AFB3-10A60801134A@.microsoft.com...
Is there any way to find out using a sql query or from registry the current
active node (physical server) of a cluster? I do not want to use the
cluadmin
gui.
if i can find out the node on which sql resources are active using a query -
it will be helpful.
cheers,
bharath