transaction id mismatch

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sankara Gara
    #1

    transaction id mismatch

    Why is the transaction id returned by the profiler (or
    sp_trace_getdat a) does not match with that in the transaction log ( as
    seen with select * from ::fn_dblog(defa ult, default) ) in SQL2000/SP3?

    Thanks,
    sg
    Tags: None
    • Simon Hayes
      #2
      Re: transaction id mismatch


      "Sankara Gara" <s_gara@yahoo.c om> wrote in message
      news:88c36928.0 404211320.5a9a5 f6@posting.goog le.com...[color=blue]
      > Why is the transaction id returned by the profiler (or
      > sp_trace_getdat a) does not match with that in the transaction log ( as
      > seen with select * from ::fn_dblog(defa ult, default) ) in SQL2000/SP3?
      >
      > Thanks,
      > sg[/color]

      No idea - fn_dblog() is not documented, so there's no way to know what that
      transaction ID really means. You may be able to find some information with
      Google, but there's no official documentation.

      Simon


        Comment

        Previous template Next
        Working...