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, "select into", 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