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