Use the sp_iqtransaction stored procedure to view the versioning type (either table-level or row-level) of each active transaction.
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. |