开发者

Is there any way to avoid the 'saving changes is not permitted' error when trying to change the schema

I'm not a SQL server expert by any means, and I'm hoping this is something simple. The scenario: I create a ne开发者_C百科w database with all the defaults, then add a table with a primary key and two nvarchar(max) fields, but I forget to set the identity specification on the key so I go back and try to change it the IsIdentity property from No to Yes and I get the following error:

Is there any way to avoid the 'saving changes is not permitted' error when trying to change the schema


Found this after posting my question - leaving up to moderators to decide if this is something to keep or not...

The simplest way to bypass this error is to go into Option – Designers and uncheck the option Prevent saving changes that require table re-creation.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜