How to read Transaction Log???

How to read Transaction Log???

Post by Alan » Sat, 11 Jan 2003 08:18:12



Some data in my DB was deleted mystically.
I want to find what statement the concealer was done.
How can I do it?
Please help me, thanks a lot.
 
 
 

How to read Transaction Log???

Post by Mandar Nai » Sat, 11 Jan 2003 08:59:51


HI Alan,

    There is only one publically available utility that I know of called
Lumigent Log Explorer which can help you do this. Please visit
http://www.lumigent.com

HTH,
Mandar.


Quote:> Some data in my DB was deleted mystically.
> I want to find what statement the concealer was done.
> How can I do it?
> Please help me, thanks a lot.


 
 
 

How to read Transaction Log???

Post by Stev » Sat, 11 Jan 2003 15:04:12


Alan,

Here's an undocumented way to look at the log file

SELECT * FROM ::fn_dblog(1,NULL)

It would take additional research for you to be able to
figure anything out from the data returned however.  

Quote:>-----Original Message-----
>Some data in my DB was deleted mystically.
>I want to find what statement the concealer was done.
>How can I do it?
>Please help me, thanks a lot.
>.