One-liner : Find out the node/ server name

In SQL Server 2000:

select * from ::fn_virtualservernodes()

In SQL Server 2005:

select * from sys.dm_os_cluster_nodes

Or this backward compatibility function:

select * from fn_virtualservernodes()

Reference: BOL

Advertisement