SQL Server2008修改表保存错误

由于项目经常要修改表结构,没办法,地球上的IT人都知道表结构不能随便修改, 但量客户那头有一个不是程序的程序员,只会简单的拖和拽和控件绑定的人,而且经常的在产品服务器上直接修改我建立的数据表, 所以上头有要求所有的字段都要照顾到该人士.(谁让人家是外国人,外包也不是那么好做的啊...)

在换上了2008之后,便弹出如下信息.

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.You have either made changes to a table that can't re-created or enabled the option Prevent saving changes that require the table to be re-created

解决方法:

Tools->Options->Designers->Table options->Prevent saving changes that require the table re-creation

把这一项uncheck了就行了.

转载于:https://www.cnblogs.com/jhabb/archive/2012/03/29/2423275.html