måndag 9 mars 2009

Default trace in SQL Server 2005

Have you ever had a problem with your sql server and the boss wanted to know who or what was responsible?
Of course you didn´t have a trace running, because you haven´t had any problems with the DB before.
You are not completely lost if you haven´t disabled the default trace which is on by default. The following query will tell you if it´s enabled or not.
select * from sys.configurations where configuration_id = 1568

In the following articles you will find a good beginners guide and which events are captured in the default trace.
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/#
http://blogs.technet.com/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspx

Regards
Stefan

0 kommentarer: