DBATAG, a TAG to every DataBAse Consultant !!!

Tag Archives: default trace location

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 [...]