I am able to get the SQL Server 2008 Design Diagram to crash reliably. I prefer to use “Custom View” with some useful column such as “Identity” and “Default Value” to make it easier to quickly get new table structures created.
I prefer to use the “Allow Nulls” checkbox column (the one you see in the Standard view) to the “Nullable” Yes/No column that is in the default Custom View (so I can more quickly spacebar NULL/NOT NULL). However, adding “Allow Nulls” then changing the column order will crash SQL Server Management studio 100% of the time.
As a workaround, you can remove any Custom View columns already in place that you wish to appear after the “Allow Nulls” column, then re-add them after you’ve added “Allow Nulls.”
My installation’s @@version:
Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
Sadly, I discovered this bug only after having spent a couple of hours putting together a database design. C’est la vie!