Re: Cause of table truncated

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/27/05 

Date: Tue, 26 Jul 2005 23:28:53 +0100

Understanding the DBCC LOG output is a bit difficult, especially as there
isn't much documentation available.

You might want to use a thid party tool like Lumigent Log Explorer, which
can read transaction logs and answer the questions like the one you've just
asked. 

-- 
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"Dliu" <Dliu@discussions.microsoft.com> wrote in message 
news:9E7A4BF4-6974-46DB-A489-BBFEBD28DF59@microsoft.com...
> We have a few tables is SQL 2000 database being truncated and don't know 
> what
> happen to them.  The database log file look-up is the way I am trying. 
> But
> dbcc does not bring too much useful information.  I appreciate it if you 
> can
> point out a few ways, which can identify the cause of this incident. 
> Thanks.
> -- 
> DL