Lee Crain (11/6/2012)
Jeff Moden,Please clarify this subject for me:
I'm almost certain that I read somewhere that a "SELECT .... INTO #Table" would automatically create the target table, then lock the TempDB database for the duration of the data insertions.
Is this true or is it incorrect information?
Thanks,
It's a myth based on a previous truth from the RTM of 6.5 and earlier. It was fixed by 6.5/SP1.
--Jeff Moden
Change is inevitable... Change for the better is not.