#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Posts
    24
    Rep Power
    0

    Mon$transaction_id is null


    In the mon$statements table, why would the mon$transaction_id be null?

    Surely all statements have to execute within a specific transaction?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    4
    MON$TRANSACTION_ID will be NULL for "idle" statements, thus prepared but currently not active/executing.

IMN logo majestic logo threadwatch logo seochat tools logo