Sorry for the previous question.

The point that I had mentioned is that we do not use this statement when working with ADO 2.5 and ADO.NET.

What I missed out there was that in those cases the transaction was controlled from the front end and on an error occuring the transaction was rolled back.

What I want to stress is that the transaction is not controlled in the backend.

Anyways it was something new and would help me when I control transaction in the backend.

Pay Respect to People on your way up. For you will meet the same People on your way down.