Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    49

    Unanswered: Sql Server Read Transaction Log

    Hi,

    I wanted to read the transaction log...is there a way??? I want to know the command executed from the transaction logs.

    DBCC TRACEON (3604)

    select * from ::fn_dblog(1,null)

    DBCC LOG (test,-1)

    Anything else apart from these??

    Regards,
    Asha

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Yup, have done that, got nothing (other than the output produced), and went back to Lumigent. So far only they (and a couple of guys out there that don't want to share the secret) and MS know what to do next to make sense out of trx log.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •