Manually Clearing the Commit Status

dbcc forget_xact purges the commit status of a heuristically completed transaction from systransactions.

dbcc forget_xact can be used when the system administrator does not want the coordinating service to have knowledge that a transaction was heuristically completed, or when an external coordinator will not be available to clear information from systransactions.

See dbcc in the Reference Manual: Commands.