In this post, I am sharing a script to enable and disable default trace in SQL Server. SQL Server 2005 introduces this default trace. Using default trace, we can capture different events of SQL Server like errors, objects changes etc. You can also run this trace file using SQL Server Profiler. The Default location of … Continue reading Script to Enable and Disable the Default Trace in SQL Server