Nested Transactions

  • Comments posted to this topic are about the item Nested Transactions

  • 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...."

  • 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.

  • 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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply