A successful implicit or explicit transaction comes to a close with this. COMMIT TRANSACTION releases the transaction’s resources, decreases @@TRANCOUNT to 0, and, if @@TRANCOUNT is 1, makes all data alterations made since the transaction began a permanent part of the database.