vpolonsk
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!!!!!
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!!!!!
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....
If you do a sp_dboption it returns that you must do a checkpoint before the change has effect....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
--------------