ADO.NET check if Rollback is possible?

A lot of this complexity is handled by using a TransactionScope object in a "using" statement - check it out on MSDN . One caveat is that a TransactionScope will automatically "scale up" to use a distributed transaction when it is deemed necessary - sometimes this is desireable, and other times it isn't, so be careful if you are nesting TransactionScopes.

The problem is that in non SQL 2005 the transactionscope is promoted to a distributed transaction which is quite an overhead.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.