SQL Server 2008 Database Diagram Crash

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!

About pyrolupus

Writer, father, teacher, programmer, performer. And I make some mean pancakes, too.
This entry was posted in SQL and tagged , , , , , , . Bookmark the permalink.

2 Responses to SQL Server 2008 Database Diagram Crash

  1. Elfi says:

    Exactly where is the facebook like link ?

  2. pyrolupus says:

    Since you asked, I’ll get around to adding one!