> When I try to modify an existing table from SQL 2000, I
> get the message 'Saving changes is not permitted. The
> changes you have made require the table to be dropped
> and recreated. You have either made changes to a table
> that can't be created or enabled the option Prevent saving
> changes that require the table to be re-created.'
> 
> How did you get  around that?

This is enabled by default and has to be turned off in most cases.  Under
Tools -> Options, select Designers.  There should be a setting in there
called "Prevent saving changes that require table re-creation."  Uncheck
that box and save the settings and it will get around that issue.


-Justin



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333961
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to