How do you enable auditing on SQL, to know when transactions are done and what is being done.
Who is Participating?
please look into auditing in books online. Also look at "c2 auditing" (careful - C2 auditing is not supported in yukon since it can bang the server).

Auditing is achieved by running the profiler. You can run either on-deman auditing by running the profiler whenever needed, or run it continuously. C2 auditing can also be achieved through the profiler.

Please read about it more in BOL, since this is a big topic that couldn't really be covered here, in a timely manner.

Hope this helps.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.