健忘症補救株式會社

使用SQL SERVER 2008的SSMS圖形介面新增、修改Table的Column時,

若是出現

"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 be re-created or enabled the option Prevent saving changes that require the table to be re-created."

訊息視窗上面的"?"按下去,Help會說明怎麼解決.

Tools-->Options-->Designers-->Table and Database Designers

把"Prevent saving changes that require the table re-creation"勾選拿掉.