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: