Menu

Want to work with us? We're on the lookout for a UX/UI Designer and Digital Project Manager.

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.