how turn on trace falg -T4606 from osql utility

• AAkula

  SSCertifiable

  Points: 5394

  More actions

  March 5, 2009 at 1:42 pm

  #129550

  Hi,

  how to turn dbcc traceon(4606,-1)" from OSQL utility.

  Our instance is default instance ABC. I need to trun on -T4606 for the ABC default instance from OSQL utility.

• Mike - CI

  SSCarpal Tunnel

  Points: 4146

  More actions

  March 5, 2009 at 1:50 pm

  #954373

  Something like

  osql -S ABC -E -Q "dbcc traceon(4606,-1)"

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 6, 2009 at 6:05 am

  #954797

  I am replying here as I am not able to view your last reply posted on

  http://www.sqlservercentral.com/Forums/Topic669605-146-1.aspx

  Is that upgrade problem resolved? If not then locate instmsdb file and specify a storng password here:

  create certificate [##MS_AgentSigningCertificate##]

  encryption by password = 'Yukon90_'------HERE SPECIFY A STRONG PWD

  HTH!

  Manu