By default, SQL Server 2008 does not permit you to recreate table (change datatype, add/remove fields, ...). If you made changes to a table and then save the changes, SQL Server 2008 will prompt :
"Saving changes is not permitted. The change you have made require the following tables to be dropped and re-recreated. You have either made changes to a table that can't not be re-created or enabled the option Prevent saving changes that require the table to be re-created."
To enable saving changes to a table, use SQL Server Managemant Studo, click Tools menu, choose options, click Designers and uncheck "Prevent saving changes that require table re-creation."
"Saving changes is not permitted. The change you have made require the following tables to be dropped and re-recreated. You have either made changes to a table that can't not be re-created or enabled the option Prevent saving changes that require the table to be re-created."
To enable saving changes to a table, use SQL Server Managemant Studo, click Tools menu, choose options, click Designers and uncheck "Prevent saving changes that require table re-creation."
Comments