Manually clearing the commit status

dbcc forget_xact purges the commit status of a heuristically completed transaction from systransactions. It 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 for more information about using dbcc forget_xact.