Post reply

What is LOP_BEGIN_XACT

  • June 2, 2011 at 11:54 pm

    #251110

    Hi all,

    LOP_BEGIN_XACT ?

    Thanks

  • June 3, 2011 at 1:53 am

    #1333536

    this explained it well

    http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/59da1ca3-d01b-4247-8536-8830149391c4/

  • June 3, 2011 at 2:22 am

    #1333541

    Thanks...

    From where I will get all the LOP_...?

    Thanks

  • June 3, 2011 at 3:41 am

    #1333557

    The log's internal structure and operations are not documented. You'll have to work them out yourself from when they occur and from what little is said in blog posts.

    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

  • June 3, 2011 at 4:12 am

    #1333565

    Thanx Gila Don't Mind but I always see that microsoft try to hide internal wokings while atleast the documentation should be like open source.like Java,PHP and Mysql.

    Thanks

  • June 3, 2011 at 4:24 am

    #1333571

    SQL Server != open source.

    Portions are undocumented because they're not guaranteed to remain the same. Documented features have to be formally deprecated before they can be removed, formally noted as to changes.

    The tran log's internal operators don't need documentation, they're not something that people need to use. If you want to explore for fun, then like most undocumented stuff you need to work things out yourself.

    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

  • June 3, 2011 at 4:36 am

    #1333573

    Thanx..I will follow...

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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