Tag Archives: SQL Server default trace

"Black Box" in SQL Server 2008

In SQL Server 2008, the Default trace is enabled by default during the installation and this default trace in SQL Server 2008 acts as a Black box for the SQL Server. Hence it is also called as "Black Box" in SQL Server 2008 and  the default trace cannot be stopped by using the Query "Exec sp_trace_setstatus 'Trace_id',0 –0 [...]

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