New answers tagged audit
I wanted to do the exact same thing and enabled Advanced audit policies. With the advanced Audit policy, roles are reversed in that you specify what you want instead of capturing everything. Because this only works with Vista and above, you might want to separate it from XP policies (for clarification, if nothing else). To do that, you would Set Computer ...
The feature is built on top of Extended Events and audits server and database events and groups of events. Database level auditing is supported only by the Enterprise and Developer editions. In SQL Server 2012, all editions support server level audits
If I understood well, you need a sort of check list and that seems like a good starting point. There are many suggested ones you can dig out using Internet, but I prefer this one. Along with the auditing topics, you can find additional ones that will be required in time, too
You can manually create appropriate DML triggers, but that requires manual set up of auditing repository too. On the other hand, the process can be automated using ApexSQL Audit, an auditing tool for SQL Server databases which captures data changes that have occurred on a database including the information on who made the change, which objects were affected, ...
Top 50 recent answers are included