Tuesday, February 10. 2009
SQL2008 Error setting new primary key
Ever got an error like 'could not save table changes that require the recreation of the table' when you tried to create a new primary-key or not-null constraint on a table using SQL Management Studio 2008?
Well, I got this error on my first steps on migrating to SQL2008.
The solution to this problem is pretty simple: an option setting in the 2008 Management Studio has to be changed, as such changes are blocked by the studio.
Just open the Management Studio, go to the Extra->Options Menu, Click on "Designer" and deaktivate the settings as show in the screenshot.
(via
http://www.dotnetnukeblog.de/SQL+Server+2008+Modifizieren+Einer+Tabelle.aspx)
/* Comments */