SQL Server 2008啟動(dòng)SSMS,開始試試IntelliSence,Import,Export等基本功能,建了一個(gè)Table想要再M(fèi)odify修改Table的Column字段定義,出現(xiàn)錯(cuò)誤 "不允許儲(chǔ)存變更saving changes is not permitted"

解法如下:

1.請開啟 SQL Server Management Studio (SSMS)

2.在 [ 工具 ] 菜單中上, 單擊 [ 選項(xiàng) ]

3.在 [ 選項(xiàng)] 窗口，巡覽窗格中, 單擊 設(shè)計(jì)工具 (英文)

4.選取或清除 [儲(chǔ)存的變更，需要重新建立數(shù)據(jù)表 ] 復(fù)選框，然后再單擊 [確定]

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.