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?



    Wednesday, October 17, 2007 5:25 PM