Joy Smith San (9/12/2012)
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.
No. Begin Tran is not necessarily required for ACID properties especially when "implicit transactionns" is turned on (the default in SqL Server). And even incorrect values beinng updated in tables can meet "ACID" properties.
Look up "ACID Properties" in Books Online and read all 3 articles that are returned on the subject.
--Jeff Moden
Change is inevitable... Change for the better is not.