none
Determining state of a transaction RRS feed

  • Question

  •  

    Is it possible for a client when running a query on a connection to determine if the table that is being read is currently under a transaction?

     

    IE, somebody is writing to that table and someone chooses to read data but is blocked waiting on the transaction to complete, is there an event or some other mechanism that allows you to find out if the block is due to a transaction?

     

    Thanks

    Wednesday, October 17, 2007 5:25 PM

Answers