Want to work with us? We're on the lookout for digital experts.

We're hiring

Saving changes is not permitted. SQL Server 2008 Issue

Web Bureau

01 February 2011 by Web Bureau

When changing tables in SQL Server Management Studio 2008 you may get the following error: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

From top menu select Tools and then Options. Select Designer and Table and Database Designers.

Uncheck the box Prevent saving changes that require table re-creation. Now you can edit your tables without being stopped by re-creation limits.

Update. As mxmissile pointed out in his comment then don't use this on tables with millions of rows.

Grow your businessStart a project with us today.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.