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.