Active Node Name in Clustered SQL Server 2000

  • There is a requirement in my application to get the active node name in SQL Server 2000. At any given point of time, there will be only one active node that hosts SQL service - my application has to be aware of that.

    Please let me know if there are any strategies to help determine the same.

    TIA.

    Appreciate a quick response.

  • EXEC master..xp_getnetname

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Sorry my earlier post gives you the instance nam

    to get hostname,

    select serverproperty('ComputerNamePhysicalNetBIOS')

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • select serverproperty('ComputerNamePhysicalNetBIOS') sorry but this doesn´t works in SQL 2000

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply