saving changes is not permitted 不允許儲存變更

---

saving changes is not permitted 不允許儲存變更

update  2022/7/14

錯誤訊息

The changes that you have made require the following tables to be dropped and re-created

解決方法

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving hanges that require the table to be re-created check box.

SSMS v18.12.1

SQL Server 2008啟動SSMS,開始試試IntelliSence,Import,Export等基本功能,建了一個Table想要再Modify修改Table的Column欄位定義,出現錯誤 "不允許儲存變更saving changes is not permitted"

解法如下:

1. 請開啟 SQL Server Management Studio (SSMS)
2. 在 [ 工具 ] 功能表中上, 按一下 [ 選項 ]
3. 在 [ 選項] 視窗，巡覽窗格中, 按一下 設計工具 (英文)
4. 選取或清除 [儲存的變更，需要重新建立資料表 ] 核取方塊，然後再按一下 [確定]

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving hanges that require the table to be re-created check box.

參考:
http://msdn.microsoft.com/en-us/library/bb895146.aspx
http://support.microsoft.com/kb/956176/zh-tw