Viewing the Versioning Type of a Transaction

Use the sp_iqtransaction stored procedure to view the versioning type (either table-level or row-level) of each active transaction.

1. Run sp_iqtransaction.
2. Examine the VersioningType column.

   VersioningType	Description
   Row-level	The transaction uses row-level versioning. Row-level versioning enables concurrent writer access and row-level locking for RLV-enabled tables.
   Table-level	The transaction uses table-level versioning. Table-level versioning enables single-writer access and table-level locking.