By Chris Alliegro [bio]
Posted: Oct. 20, 2008

The following is an illustration accompanying an article published by Directions on Microsoft, an independent research firm focused exclusively on Microsoft strategy & technology. More samples of our content, as well as a list of upcoming articles and reports are also available.

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.