Discovering SQL Installations

• co_patrickf

  SSC Enthusiast

  Points: 130

  More actions

  June 17, 2002 at 11:15 am

  #57675

  I have 200 servers in my enterprise and I need a programmatic way to discover what SQL installations exist without having to go to each machine. There must be a way to browse the network to discover this.

  Any ideas?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  June 17, 2002 at 1:40 pm

  #431033

  If you use SQL-DMO, there is a method to look for SQL installations. Note that this may not work, especially if you are subnetted.

  Check the MSDN docs

  Steve Jones

  steve@dkranch.net