Help on SQL server 2000 1

[Fampofo]

Hi Everyone I am trying to use 'select into' statement to copy a table and its contents to a new table
This is the error message I got
" Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option."
Can you help me. Thanks

 

[ColinM]

Try issuing this command

exec sp_dboption 'dbname', 'select into/bulkcopy', 'true'

replacing dbname with your database name