Cannot Save Changes That Require Recreate

I know we have all had this at least once. We tend to fix it and forget it. I had it today at work and had to look it up. We all know what that means, its going in my e-Brain.

This is for when you design a table in SSMS (SQL Server Management Studio) and when you try to save the changes you cannot. You get a message like the one below.

The fix is really simple of course. In SSMS go to your Tools, and then Options. In that dialoge box that comes up go to Designers. There you will see a checkbox for

Prevent saving changes that require table re-creation

Remove that check mark and click O.K. You will be good to go. Dropping and re-creating tables as needed when you click save.

About SheldonS

Web developer for over 15 years mainly with Microsoft technologies from classic ASP to .NET 4. Husband, father, and aspiring amateur photographer.

Posted on March 29, 2012, in SQL and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: