Reading Transaction Log

  • Suddenly my database went to an inconsistent state..certain queries showed there was a wrong value updated in one of the tables. I was wondering whether it was my application which caused this or a user updated it accidently. I decided to check the transaction log in order to see the update command possibly run. Unfortunately i was not able to figure out this from the dbcc log (databasename, type = 4) Is there any way I can find the exact command that was executed.


    Jesus My Saviour

  • You'll need a 3rd party product like LogExplorer by Lumigent.

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply