SqlServer2008修改表栏位提示权限问题

来源:互联网 发布:淘宝店铺托管公司排名 编辑:程序博客网 时间:2024/06/05 18:51

使用SqlServer2008 在修改表栏位或者随便将个栏位修改为Indetity时都提示权限问题

Saving Changes is not permitted.The changes you have made require the following tables to be dropped and re-created...

 

而sqlserver2005的Management Studio因为版本低无法连上SqlServer2008的数据库

而具体的设置就是打开SqlServer2008的Management Studio,

点击Tools->Options->Designers->Table and Database Designer->

取消勾选Prevent Saving changes that require table re-creation