Thanks for the quick responses. As I told even I was not clear.

Yes, I know ACID properties. Just confused with the question.

However would it be ideal if I say,

1. A transaction should be opened with "Begin Tran".

2. Ensure that correct values are updated in the tables.

Thanks again.

San.