Post reply

SQL Servers

  • May 18, 2005 at 11:54 pm

    #167073

    Dear All!

    I want to display all available SQL Servers over a local network.

    I have found a C# code to display all SQL Servers but want to find out if,

    Is there is any possibility to list the SQL Servers over a network in T-SQL?

    Thanx in Advance...

     

    Thanx + Regardz,

    Jan whY? Jan

  • May 19, 2005 at 12:40 am

    #559782

    Nope. You can list the servers which are 'linked', using sp_linkedservers, but listing all the SQL Servers on a network isn't something that T-SQL is designed for.

    Sorry. You'll have to use your C# code.

    Rob Farley
    LobsterPot Solutions & Adelaide SQL Server User Group
    Company: http://www.lobsterpot.com.au
    Blog: http://blogs.lobsterpot.com.au

  • May 19, 2005 at 11:36 am

    #559948

    Somebody posted a script here using ISQL/OSQL some time ago as I recall.  Try searching for that in the script area.

  • May 20, 2005 at 9:58 am

    #560262

    osql -L or isql -L

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

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