Paul,

Thanks for the full explanation. It makes complete sense now.

Jeff,

Thanks for your time and full test. You do a fine job of myth busting. I've used your reference on SELECT INTO #Temp not actually locking sysobjects in TempDB several times to resolve arguments with DBA's

Todd Fifield