Wednesday, April 21, 2010

SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted

Are you having this message when you are trying to change a table Design (columns type, name and etc..)?

It's easy to resolve:

In Microsoft SQL Server Management Studio click on "Tools > Options".
Expand "Designers" and click on "Table and Database Designers".
Uncheck the option "Prevent saving changes that require table re-creation".

Try again,..

and..

Solved!

No comments:

Post a Comment