Determining which connection has an outstanding transaction (SQL)

You can use a system procedure to determine which user has outstanding transactions.

Prérequis

You must have the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.

Contexte et remarques

If you are performing a backup that renames or deletes the transaction log, incomplete transactions are carried forward to the new transaction log.

Résultat

Inspect the UncommitOps column in the Results pane to see which connection has uncommitted operations.

Suivant

If necessary, you can disconnect the user with a DROP CONNECTION statement.