Fine-grained auditing in SQL Server?

Yes, via a variety of mechanisms, but it isn't an option you turn on.

Method #1: Write triggers underneath each table that log all of the auditing information.

Method #2: Create a server side trace that will trace all activity against your database, storing the file where you can pull it for review.

Method #3 (low transaction volumes only): Create a server-side trace and store the results directly to a table in your database.

Method #4: Use a product like Lumigent's Entegra to audit the system.

For More Information

• Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
• The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
• Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.