List of Instances running in a machine

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  March 12, 2011 at 10:48 pm

  #246737

  Hi !Is there any query or scripts to get the list of instances running on a machine?if so please let me know

  Thanks in advance

  🙂

• Sandesh Segu

  SSC-Addicted

  Points: 415

  More actions

  March 13, 2011 at 3:13 am

  #1298088

  Check out this link.

  http://www.sanssql.com/2011/03/t-sql-query-to-find-number-of-instances.html

  Regards,
  Sandesh Segu
  http://www.SansSQL.com

• chetanr.jain

  Hall of Fame

  Points: 3938

  More actions

  March 14, 2011 at 8:56 am

  #1298374

  Nice.. Short and Sweet.