<div>
To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.
</div>


To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

PreventSavingChanges-3.bmp

<div>
<div class="content wysiwyg-content">
I upsized an access 2007 db to mssql 2008 with data coming over as well. &nbsp;I am trying to add a key field and change various parameters and i cannot because i get a box that says: &quot;Saving changes is not permitted. &nbsp;The changes you have made require the following tables to be dropped and re-created. &nbsp;You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.<br />
<br />
How do i solve this problem? &nbsp;I am using MSSQL server management console. <br />
<br />
thanks<br />

</div>
</div>


I upsized an access 2007 db to mssql 2008 with data coming over as well.  I am trying to add a key field and change various parameters and i cannot because i get a box that says: "Saving changes is not permitted.  The changes you have made require the following tables to be dropped and re-created.  You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

How do i solve this problem?  I am using MSSQL server management console. 

thanks


How do I disable option that prevents me from saving changes that require the table to be re-created

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.