Generally Trasnsaction Commit and Rollbcak is used in SQL Serve when user want to perform Add, Modify and Delete operation but he don't want to submit changes into the database until last statement execute successfully. Means the situation where eit
Read this post on technisher.blogspot.com