Error message when you try to save a table in SQL Server: "Saving changes is not permitted"

To change the Prevent saving changes that require the table re-creation option, follow these steps:

  1. Open SQL Server Management Studio (SSMS).
  2. On the Tools menu, click Options.
  3. In the navigation pane of the Options window, click Designers.
  4. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

 

 

http://support.microsoft.com/kb/956176

Add comment

biuquote
  • Comment
  • Preview
Loading

Sponsored by

Calendar

<<  February 2019  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
25262728123
45678910

View posts in large calendar

RecentComments

TextBox