Data in table is deleted

Hi!
I have a problem with table in a SQL Server 2000 box. It seems like the
table is truncated from time to time! I don't know why and it has just
started occuring, but it happens maybe once a week now.
Is there any way to monitor if a delete statement occurs on just that table?
Is it possible in Profiler to monitors just action against one table?
Any hint or tips would be greatly appreciated!!
regards
Fredrik
Yes you can have profiler monitor a single table... Set the table in the
filter clause... Delete is not the same as truncate however, so watch for
both...(Delete will run a trigger, if one exists, and truncate does not.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:7631AE53-49D2-4504-8A87-6FB5C61FB517@.microsoft.com...
> Hi!
> I have a problem with table in a SQL Server 2000 box. It seems like the
> table is truncated from time to time! I don't know why and it has just
> started occuring, but it happens maybe once a week now.
> Is there any way to monitor if a delete statement occurs on just that
table?
> Is it possible in Profiler to monitors just action against one table?
> Any hint or tips would be greatly appreciated!!
> regards
> Fredrik