Posted on 2005-04-22
Medium Priority
Last Modified: 2010-03-19
How do you enable auditing on SQL, to know when transactions are done and what is being done.
Question by:pfslink

Accepted Solution

obahat earned 1000 total points
ID: 13843769
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.

LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 1000 total points
ID: 13847418

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question