Post reply

Detecting SQLServer Instances on the Network?

  • June 12, 2009 at 1:54 pm

    #134997

    Hi there - does anyone know if there's a way to generate a list of all the sqlserver instances (not just the host name) on the network? Thanks!

  • June 12, 2009 at 2:13 pm

    #1008888

    at a command prompt

    SQLCMD -L

    The output is a bit variable though - probably due to network response times, but its good for a quick idea of what's there.

    also OSQL -L

    but the latter gives aliases too - even if they're not currently on the network.

Viewing 2 posts - 1 through 1 (of 1 total)

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