Workers specify database audits using the SQL Server Management Studio administrative tool. This illustration shows an audit that directs SQL Server 2008 to log every select, update, insert, or delete operation on a table called Sales.CreditCard. These events can be logged to a file or to the Windows Application or Windows Security logs. In addition to Management Studio, workers can define audits using SQL Server's T-SQL programming and query language.

Back to associated article: SQL Server 2008 Improves Auditing, Change Tracking