Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Apr 30, 2012 02:02 PM|LINK
Are you planning to call multiple sp from one another? If no then use transaction scope at the code level to ensure that the code work in transaction. It should complete enitrely or nothing.