how to explore/ retrieve SQL Server Transaction Log information

  • Can anyone advise me on how to explore/ retrieve SQL Server Transaction Log information e.g. interprete record of table/ row update/ delete command, including the information of host computers and user IDs, timestamps etc.?

    Or, Can anyone help me quoting any effective software that can do this on any previous transaction?

    Or, Can anyone advise me whether "eVisie TransactioneXplorer" or similar software can do that?

    My email:hasib.hasan@gmail.com

  • Try reading this link:

    http://decipherinfosys.wordpress.com/2008/11/12/a-useful-undocumented-function-fn_dblog/

    If it helps or does not help please post back to let others know.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1359769-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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