April 13, 2004 at 12:40 pm
What is the best way to audit a users (SQL account) activity on a particlular database?
April 13, 2004 at 1:14 pm
If it is a one off trace for a relatively short amount of time, I would use 'sql profiler'. You can set the filters to a database and a user, hence narrowing down the tracing.
It is best to monitor a few events rather than the lot.
Otherwise you could setup a server side trace. See sp_trace* in books online.
Steven
April 13, 2004 at 2:25 pm
Profiler is the best way. Cumbersome and only for point use.
August 24, 2009 at 11:33 pm
Hi there
I want to imlement something similar. How did you go in the end?
Your help/advice is appreciated.
Thanks
Brandon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply