SQL2008 Error setting new primary key

Tuesday, February 10. 2009

SQL2008 Error setting new primary key

SQL 2008 Management Studio Options Screenshot

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)

Posted by Christian Fonden in SQL Server at 10:00 | Comments (0) | Trackbacks (0)

< Order by sorting tree structures | WCF Service Hosting - Enpoint Hostnames >

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

No comments

Add Comment

Name
Email
Homepage
In reply to
Comment: You can use [geshi lang=lang_name [,ln={y|n}]][/geshi] tags to embed source code snippets.
Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.

Enter the string from the spam-prevention image above:
: Remember Information?
Subscribe to this entry