March 6, 2023 at 12:00 am
Comments posted to this topic are about the item Nested Transactions
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 6, 2023 at 1:05 pm
My favorite response on that one was, "Wait, why wouldn't SQL Server have nested transactions?" The client developer was just utterly dumbfounded.
Me: "Well, why WOULD it?"
Developer: "It just has to - it didn't give me any warnings."
Me: "Oh, if only they coded in warnings for everything...."
March 6, 2023 at 4:41 pm
In all fairness it is fairly unintuitive that SQL server will let you begin named nested transaction even though it doesn't actually create a new transaction, not complain about it, including only complaining if you try to roll them back but not if you try to commit them.
March 7, 2023 at 2:45 pm
If only MS coded every bit of guidance into the docs and warnings...
The big thing I was hoping to point out is you should test whatever you want to happen. Make sure the product does what you need.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply