Post reply

Extract T-SQL from transaction logs

  • October 12, 2010 at 2:01 pm

    #387993

    I've seen all sorts of postings about viewing the logs and I see the transaction and the operation definitions. Is there any way to extract the T-SQL statement that created a particular set of rows in the transaction log? I've got a failed sql statement which is about 5 minutes old that I need to track down.

    Any ideas?

    Don

  • October 12, 2010 at 2:12 pm

    #1235862

    No. T-SQL is not stored in the log.

    Tried querying the plan cache? If the query was recent, it may still be in there.

    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

  • October 12, 2010 at 2:17 pm

    #1235864

    Sigh, sometimes I feel very far out of my depth.

    I'll look into querying the plan cache, thank you.

    Don

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

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