April 2, 2003 at 4:28 pm
We are using SQL 2000 sp2 on NT. We have a need to create and update a simple audit trail. A table would be updated when a user accesses a specific database on our system. All we need is the userid and a login date. I know profiler does this, but I don't want to run it for 2 months.
Any brillant ideas would be appreciated. A problem we have is the users access the database thru a 3rd party application.
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 3, 2003 at 12:13 am
You can use server side traces to record this information, then load it into a table.
See the follwing link for more detils http://www.sqlservercentral.com/columnists/hji/trace.asp
Steven
April 3, 2003 at 10:27 am
Thanks. The article is exactly what I needed.
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply