Home > SQL Server > How to work around “Saving changes is not permitted” prompt in SSMS

How to work around “Saving changes is not permitted” prompt in SSMS

In a recent update to SQL Server Management Studio (I believe SSMS for SQL Server 2008 R2), changes made via the table designer that require a table to be dropped and recreated result in the following message:

“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 go back to legacy behaviour where SSMS will just drop and re-create the table for you, go to Tools–>Options–>Designers and untick the box “Prevent saving changes that require table re-creation”.

-Krip

source

Advertisements
Categories: SQL Server Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: