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,