• ah, thanks George! I wasn't planning on investigating further after Hugo's authoritative explanation, but I was a little weirded out that the BOL (2000) documentation I was looking at mentioned only the TempDB!

    http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.