Hmm, never really thought about ACID properties vis-a-vis tempdb: a transaction is a transaction, right? 😉

Fortunately, the "durable" choice screamed at me "Yo! You think I'll still have your precious data on the next server restart, dog?"

Nice question: easy, but only after I had to think a bit.

Rich