Integrate Transactions and Error Handling in SQL Server