yeah... http://www.lumigent.com This software is not free.
There are some undocumented commands like DBCC LOG that will let you examine
the log, but it is difficult to interpret the output without the
Some DBAs implement auditing (using triggers) on all crucial tables. When
something goes wrong, they check the audit tables to see what went wrong,
when and by who etc.
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
what if I do not have the the 3rd party tools? any other
ideas? is the Lumigent software free ... is that the name
of the vendor?
>If you have a transaction log backups that cover this
time period, then you
>can use a third party tool like Lumigent Log Explorer to
>Vyas, MVP (SQL Server)
>What hardware is your SQL Server running on?
>HI! I'm running SQL2000 and lost several rows of data
>somewhere over the past 3 weeks. I can recreate the
>entries, no problem... but I'd like to track what happened
>to them, more specifically when and who deleted the data.
>Any suggestions on where to start looking?