|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
 |
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 Why SELECT INTO statement does not work? Answer: First of all, chect the syntax of your SELECT INTO statement. If the syntax is correct, check that the select into/bulkcopy database option is turned on. To check that the select into/bulkcopy database option is turned on, you can use the Enterprise Manager or the sp_dboption system stored procedure. For example, to check that the select into/bulkcopy database option is turned on for the pubs database, you can use the following statement: EXEC sp_dboption pubs, 'select into/bulkcopy' To turn on the select into/bulkcopy database option, you can use the following statement: EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'TRUE' Read SQL BOL to get more information about the sp_dboption system stored procedure. |