SQL Management 2008 Error: `Saving changes is not permitted.`

Are you getting this error when you try to change any of the information in your database? 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. To fix this error, go to *Tools* -> *Options* -> *Designers* -> *Table and Database Designers* and uncheck the Prevent saving changes that require table re-creation checkbox. This will remove the block that was enabled.
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Do you allow remote MSSQL access?

Yes. We do allow remote access to the MSSQL. It is offered on the regular port...

Helm shows MSSQL 2005. I thought you offered MSSQL 2008?

Yes. The MSSQL server is 2008 however since Helm's theme/skin does not offer a way to add MSSQL...

Is there a limit to the size of a database that I can have?

Yes. MSSQL databases are limited to a size of 3 GB.

Do you have a connection string I can use to connect to the local MSSQL database?

 Yes. Please use the following connection string and fill in the necessary spots with your...