asked on

ERROR: The 'select into' database option is not enabled for database 'ipaddb'.

Hi,

I need to drop a column and im using this sql:

alter table Attachment drop attachmentType

i get this error message:

ERROR: The 'select into' database option is not enabled for database 'ipaddb'. ALTER TABLE with data copy cannot be done. Set the 'select into' database option and re-run.

seems clear, i set this option and everything should be ok, so i run this:

--------------
use master
go
sp_dboption ipaddb, 'select into', true
go
sp_helpdb ipaddb
go
--------------

and the options seems to be set since i receive this output:

name db_size owner dbid created status
---------- ---------- ---------- ---------- ---------- ----------
ipaddb | 250.0 MB | ipad | 39 | Dec 01, 2003 | select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full |

----

but, for some strange reason - it doesnt help, i get the same error as before:

ERROR: The 'select into' database option is not enabled for database 'ipaddb'. ALTER TABLE with data copy cannot be done. Set the 'select into' database option and re-run.

PLEASE HELP!!!!!

vpolonsk

ASKER

ok.. figured it out on my own:
needed to use checkpoint command, so this worked :
--------------
use master
go
sp_dboption ipaddb, 'select into', true
go
use ipaddb
go
checkpoint
go
sp_helpdb ipaddb
go
--------------

ahoor

You should always listen to your database :)
If you do a sp_dboption it returns that you must do a checkpoint before the change has effect....

ASKER CERTIFIED SOLUTION

modulo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial