Microsoft KB Archive/69331

INF: SQL SELECT INTO Option for TEMPDB and Temporary Tables ID Number: Q69331

1.10 1.11 4.20 OS/2

Summary:

When creating a temp table with the SELECT INTO statement, the SELECT INTO/BULK COPY option does not need to be set for the database you are currently in. However, the SELECT INTO/BULK COPY option must be set to “true” in the TEMPDB database. To set this option to “true,” execute the following commands from the MASTER database:

sp_dboption tempdb, &quot;select into&quot;, true go For more information on the SELECT INTO command, query on the following words in the Microsoft Knowledge Base:

Prod(sqlndk) and permanent and owner Additional reference words: 1.10 1.11 4.20 Transact-SQL