Rollback Transaction in SQL Server

Commit and Rollback Transactions in SQL Server 2005/2008 is a huge topic in itself. In this article, I will explain how to use a Try..Catch block to commit and rollback transaction. In subsequent articles, we will explore how to rollback nested transactions too