Tag Archives: default trace @DefaultTraceEnabled

Default Trace in SQL Server

SQL Server 2008 and 2005 has a default trace running. As BOL states: “Default trace provides troubleshooting assistance to database administrators by ensuring that they have the log data necessary to diagnose problems the first time they occur.” The default trace provides auditing on schema modifications such as table creation and stored procedure deletion etc [...]