http://www.sqlservercentral.com/Content tagged Auditing, SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/2008/11/11http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/Auditing data changes in your production environment is very important, especially if you are dealing with confidential information.http://www.sqlservercentral.com/redirect/articles/64669/2008/10/23http://www.sqlservercentral.com/redirect/articles/64669/Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.http://www.sqlservercentral.com/articles/Auditing/62126/2008/02/29http://www.sqlservercentral.com/articles/Auditing/62126/As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.http://www.sqlservercentral.com/redirect/articles/61422/2007/11/16http://www.sqlservercentral.com/redirect/articles/61422/