Logs

Hi
I have a database In SQL server and I want to keep a log of all the
activityâ's that that the end user did I want to know who did and what he
did and when he did what is the bet way to keep track on that. In my previews
application I made a logs table with fields tableid, tablename, userid
,action, datetime and then always when insert update or delete in table we
save it also to logs, is this idea good for SQL server or there is a better
way to do it with SQL server archivingRead about blackbox in Books Online and see if thats what you were looking
for.
Or use profiler.
Thanks,
Sree
"hershel" wrote:
> Hi
> I have a database In SQL server and I want to keep a log of all the
> activityâ's that that the end user did I want to know who did and what he
> did and when he did what is the bet way to keep track on that. In my previews
> application I made a logs table with fields tableid, tablename, userid
> ,action, datetime and then always when insert update or delete in table we
> save it also to logs, is this idea good for SQL server or there is a better
> way to do it with SQL server archiving
>