Does an out-of-the-box newly created database (in SQL Server 2008) keep any DML audit records, such as:
- User 'George' did an insert on table 'Alpha' on 6/20/2011
- User 'Fred' did a delete on table 'Beta' on 6/21/2011
If yes, how do I access that information? If not, what is the easiest way to turn it on (I presume these are the audit options).