Where is the TRACE output ??

• Girish Patil

  Old Hand

  Points: 344

  More actions

  April 2, 2004 at 2:26 am

  #65051

  Hi Guys,

  I have been reading and trying these trace flags. But I'am unable to find the where the trace output is going.

  http://www.sqlservercentral.com/columnists/RDyess/traceflags_printversion.asp

  This below command will enable two traces

  1704 - "Prints information when a temporary table is created or dropped."

  3604 - "Sends trace output to the client. Used only when setting trace flags with DBCC TRACEON and DBCC TRACEOFF."

  DBCC TRACEON(1704, 3604) -- to enable the traces

  GO

  DBCC TRACESTATUS (-1) -- to see whether the TRACES are running or not

  GO

  Then I ran this ( EXEC sp_spaceused) command, b'cos I wanted to see the Temporary tables creation. But TRACE didn't return any message in the Quary Analyser's Result Pane

  So where is the TRACE OUTPUT going ???

   

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 2, 2004 at 4:35 am

  #501569

  Some traces are directed to the SQL Server Logs. I do believe 1794 may be one of those.