2010年5月3日 星期一

SSMS 2008修改表格

在SSMS 2008的介面設計TABLE時, 如果新增或刪除欄位後按下儲存, 會出現
Saving changes is not permitted. The changes you have mad require then following tables to be dropped and re-created.......

懶得貼圖了

GOOGLE看到這篇文章 , 才知道, 訊息視窗右上方除了一個X之外,還有一個?, 按下去之後, SQL Server的HELP就告訴你要怎麼解決囉, 如下...

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 changes that require the table to be re-created check box.

沒有留言:

張貼留言

離線安裝SSMS 22 launched extracted application exiting with result code 0x138b

SSMS 22 安裝器下載頁面 https://learn.microsoft.com/zh-tw/ssms/install/install https://aka.ms/ssms/22/release/vs_SSMS.exe 將安裝檔下載到本機,檔案好大2.5G  https:...