One frequenctly asked question is, "How do I find out via T-SQL which cluster node is running this SQL Server instance?"
There is no easy way in SQL Server 2000 or SQL Server 7.0 to determine the current node of a SQL Server instance using T-SQL. The approach I use often is to run cluster.exe through xp_cmdshell, assuming you know the SQL Server resource name or the group name of your current SQL instance. You can then read the output to determine the current node. But it's rather ugly if you want to use the information programmatically in a T-SQL script.
By the way, serverproperty('MachineName') gives you the virtual server name of the current instance, serverproperty('ServerName') gives you <virtual server name>\<instance name>, and serverproperty('InstanceName') gives you the current instance name without the virtual server name prefix.
EXEC xp_cmshell 'hostname' gives you the current virtual server name, so does EXEC xp_cmdshell 'echo %computername%'.
Good news is that in SQL Server 2005 there is a server property called ComputerNamePhysicalNetBIOS that will return the current cluster node name, a T-SQL property that is long overdue.