What, When and who? Auditing 101 - SQLServerCentral

SQL Server Central has a nice look at options for auditing SQL server in their article What, When and who? Auditing 101

Frankly, after looking through them, if you want to audit Dynamics GP just buy FastPath's Audit Trail product and save yourself a lot of work.