March 6, 2023 at 12:00 am
Comments posted to this topic are about the item Nested Transactions
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy