Expert: Peter Choi - 6/23/2009

Question
Sir, Kindly give me the difference between the Tracing and Auditing in SQL

Answer
Hi Jasvinder,

When you're performing a trace you are following step by step what the SQL is doing. This is typcially used when trying to debug, optimize or improve the performance of a piece of SQL code.


When you're audting an SQL, you are reviewing the actions that have been performed by (or the result of executing) the SQL. Auditing can be used for forensic investigation, routine check, or verification of the data integrity.

Hope this helps.

Peter