I am new to sql server. I would like help from you gurus out their. I wanted to audit the activites (DML) on my database. I wanted the audit to achive the following
1] Audit specific tables for the DML activities.
2] capture the details of the username, time and system from which this query executed.
3] Can i get the changed and the previous values.
4] I don't want to use the triggers.
I did read in some articles this is achivable with the help of SQL-profiler and osql but don't know the exact steps. Could some one provideme with the step by step guide to get this done?