Friday, April 26, 2013

Verify Default Trace Status in SQL Server


Below is the process to verify default trace status

To get the name and location of the default trace that is currently runningSELECT * FROM :: fn_trace_getinfo(default)

To verify whether default trace option is enabled or not
select * from sys.configurations where configuration_id = 1568


Displays information about traces that are running
  select * from sys.traces

To enable default trace in SQL Server

sp_configure 'show advanced options',1
reconfigure

 sp_configure 'default trace enabled', 1
reconfigure

To restart default trace in SQL Server

sp_configure 'show advanced options',1
reconfigure

 sp_configure 'default trace enabled', 0
reconfigure

 sp_configure 'default trace enabled', 1
reconfigure

1 comment:

  1. Fantastic article ! You havemade some very astute statements and I appreciate the the effort you have put into your writing. Its clear that you know what you are writing about. I am excited to read more of your sites content.
    http://www.sqlservermasters.com/

    ReplyDelete