Determining which connection has an outstanding transaction (SQL)

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

Prerequisites

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

Context and remarks

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

Results

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

Next

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