2005 has this:
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS');

Is there a way in SQL 2000 to get the specific cluster node name where
the current instance is active?

Thanks in advance.

n

MS Sql Server LazyDBA home page