SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted

by dotnetpete 16. September 2008 07:50

Installed Management Studio 2008 the other day and have been struggling with it ever since. It's been winning until now. I try to add new columns in their place within the table structure. However I couldn't save any changes because I was not allowed to save changes if I added a new column in the middle of the column list. If I added one at the end it would save ok. When I ran into this problem I would flick back to Management Studio 2005 to do the change. 

Pulled my finger out and decided to see if there was a setting that controlled this behaviour. Found this article by Brian Knight on the issue:

SQL Server 2008 Designer Behaviour Change

Tags: ,