June 16, 2005 at 7:06 pm
Hi all. This is my first post in fact i new in this forum.
I got this question: Have you ever know how to audit user on SQL so you can know which users are inactive?
I tried ApexSql Audit but it didnt worked to perform that action.
Thanks in advance.
jabm
June 16, 2005 at 10:34 pm
We setup a trace file using profiler, then scheduled the trace to run on startup. We capture the information to a table, so we have a record of every time a user logs in. This is really the only way to track "active users" unless you have something built in to your applications to do this logging process for you. There might be tools for this built into the Lumigent suite. I would look into that. They have a whole compliance and auditing tool I haven't used yet. I love their Log Explorer though.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply