Mention what is uncommittable transactions?

Technology CommunityCategory: T-SQLMention what is uncommittable transactions?
VietMX Staff asked 3 years ago

When an error occurs in a transaction within a TRY block, and if the error is not serious it enters into a status open and Uncommittable. In an uncommittable state, the transactions cannot perform any action that would generate a write to the transaction log.