Auditing IN SQL 2k

Hello
I need to record the activities/changes in certain tables in my application
including who effected the change,time, the field that was changed, the new
and old value of the field. How do i go about doing this? I need to do this
without actually making code changes in my application.
Would be quite helpful if someone could help me with clear steps as to how
this is to be done as I'm a newbie to this field.
Thanks in advance
Regds
RachelTake a look at
http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx
You could also do a Google search on "SQL Server 2000 Auditing" which will
turn up alternatives. For example:
http://www.akadia.com/services/sqlsrv_table_auditing.html
Hal Berenson, President
PredictableIT, LLC
"rachel" <rachel@.discussions.microsoft.com> wrote in message
news:7F547B93-A7FF-4200-93DB-8980A1E8A53E@.microsoft.com...
> Hello
> I need to record the activities/changes in certain tables in my
> application
> including who effected the change,time, the field that was changed, the
> new
> and old value of the field. How do i go about doing this? I need to do
> this
> without actually making code changes in my application.
> Would be quite helpful if someone could help me with clear steps as to how
> this is to be done as I'm a newbie to this field.
> Thanks in advance
> Regds
> Rachel
>
>