Michael Gerholdt (11/30/2012)
Somehow the TransactionOption had got set to "Required" on the first container, but not the others.Setting it back to "Supported" provided the expected behavior.
Much appreciated!
My pleasure. Sounds like a misclick somewhere along the way then, or something silly happened in the background. Glad that resolved it. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA