SQLDiag Utility

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 23, 2010 at 9:23 am

  #219604

  Hi,

  Is it possible to run sqldiag utility for a particular sql instance on a machine if there are than two instances(SQL 2005) on the same machine?

  Please advice how to run it against a particular instance.

  Thanks in advance,

  MJ

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 26, 2010 at 9:44 am

  #1157707

  Anyone?

• ravikanth.

  Hall of Fame

  Points: 3472

  More actions

  April 26, 2010 at 9:55 am

  #1157715

  Check this

  http://www-01.ibm.com/support/docview.wss?uid=swg21275646

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 26, 2010 at 2:08 pm

  #1157869

  Ravi,

  My question is specific to sql 2005. Your link is for sql 2k.

• MattJ610

  Grasshopper

  Points: 15

  More actions

  April 30, 2010 at 4:14 pm

  #1160805

  I believe that you can set it in the SQLDIAG.XML file:

  <Instance name="<instance name>" windowsauth="true" ssver="9" user="">

  If you are running SQLDIAG as a service you will need to re-register it in order for it to pick up the changes to the config file.

• Paul Brewer

  SSCrazy

  Points: 2955

  More actions

  February 20, 2012 at 6:26 am

  #1449216

  For the default instance name, use 'MSSQLSERVER'