Post reply

Active Node Name in Clustered SQL Server 2000

  • December 11, 2009 at 1:00 am

    #156491

    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.

  • December 11, 2009 at 4:29 am

    #1091077

    EXEC master..xp_getnetname

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

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

  • December 11, 2009 at 5:13 am

    #1091088

    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]

  • May 7, 2015 at 3:18 am

    #1796135

    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