Implement SQL Server Transaction Retry Logic for failed transactions
Error Handling in SQL Server with Try Catch
Exception Handling Using Try Catch in SQL Server - Dot Net Tutorials
TRY CATCH | SqlHints.com
What is SQL Transaction with examples
SQL Server Exception Handling with TRY, CATCH and THROW
SQL SERVER - Msg 1206, Level 18, State 118 - The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction - SQL Authority with Pinal Dave