Re: how to trace the file activity??????

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/27/04 

Date: Wed, 26 May 2004 22:31:57 -0400

There are several ways. One is to add a trigger to every table you wish to
audit that keeps track of all this activity. Of coarse this doesn't help
for any activity that already happened. Another much easier way is to use a
3rd party product such as Log Explorer from www.lumigent.com to look at the
log files and see the history. Of coarse if you have already truncated the
logs you may not have the information. 

-- 
Andrew J. Kelly
SQL Server MVP
"sharon" <anonymous@discussions.microsoft.com> wrote in message
news:130a901c44390$4ac6a320$a601280a@phx.gbl...
> Dear all,
>        It urgent, can anyone please tell me how to race
> the activity which the user have done to the file. e.g.
> When the user delete a record from the file, when the
> user edit a record from the file and when the user add a
> new record to a file from the EM.Please, help.. Thanks.
>
> Regards
> Sharon
>
>
> .
>
>