Audit a Table

Hello,
How do I audit who is changing data in a table ? SQL 2000
We have a table and records keep getting deleted ...........
in a User Database.
Thanks
MaTTMatt,
you could create triggers which write these details to an audit table if you
want to do this continuously, or as a temporary measure you could run a tool
called Profiler and monitor the TSQL and Stored Procedure events.
Regards,
Paul Ibison|||Also there is a tool from Lumigent which will do what you wish...
www.lumigent.com
I think there may be a second vendor which can do this as well, but I don't
remember the name...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"matt" <matt.smith@.jacobsonco.com> wrote in message
news:eNkbMxsLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How do I audit who is changing data in a table ? SQL 2000
> We have a table and records keep getting deleted ...........
> in a User Database.
> Thanks
> MaTT
>