dbcc traceon

• W R

  SSC-Addicted

  Points: 463

  More actions

  November 8, 2006 at 9:44 am

  #61572

  After  dbcc traceon (3605, 1204, -1) has been executed, does stoppig and starting SQL Server set the trace off.

  Thanks.

  -W R

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 8, 2006 at 11:26 am

  #670662

  Yes. If you would like to set this audit all the time, following the steps below.

  •	Start SQL Server Enterprise Manager.
  •	Select, and then right-click the server.
  •	Click Properties.
  •	Click Startup Parameters.
  •	In the Startup Parameters dialog box, type -T1204 in the Parameters text box, and then click Add.
  •	In the Parameters text box, type -T3605, and then click Add.
  •	Click OK.

  You need to restart your SQL Server after this procedures.