An example of a stored procedure using the newer TryCatch block with transactions. Much cleaner and easier than the older style using trapped errors.

Click the download button for StoredProcedure_TryCatchTransaction.txt... Download Code