> 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