Merge Required Before Table Level Modification

Problem: You receive the error message "Table N requires an RLV store merge before table-level modification".

Explanation A

A table-level (TLV) read-write operation is attempting to modify a row-level versioning (RLV) enabled table with the BLOCKING option set to OFF. This TLV transaction requires a merge of the RLV store, but because BLOCKING is set to OFF, it cannot wait for the automated merge to complete. To correct, try:

Setting the BLOCKING option ON, and ensuring that the first statement in the transaction is a table-level read-write.
Performing a manual merge before the table level DML transaction, using the sp_iqmergerlvstorestored procedure.

Explanation B

A table-level (TLV) read-write operation is attempting to modify a row-level versioning (RLV) enabled table. This TLV transaction requires a merge of the RLV store. However, this merge cannot occur automatically because the TLV transaction has already established a snapshot version for this table. To correct, try:

Ensuring that the first statement in the transaction is a table-level read-write.
Performing a manual merge before the table level DML transaction, using the sp_iqmergerlvstore stored procedure.

Explanation C

A TLV transaction is attempting to modify multiple RLV-enabled tables. To correct, try:

Dividing the transaction so that individual transactions each modify one RLV table.