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

No comments: