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