Show Mobile Navigation

Ads

Tuesday 21 January 2014

,

Saving changes is not pemitted in SQL Server [Solved]

Unknown - Tuesday, January 21, 2014
Recently am faced the problem when am changing table columns in SQL Server Database. here is the solution.

Error: Saving changes is not pemitted. 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 tables to be re-created.

 Saving changes is not pemitted in SQL Server [Solved]

Step 1: Open your SQL Server in Administrator mode

Step 2: Click on Tools --> click on Options



Step 4:     The below window will appear then Click on Tables and Database Designers in left panel --> Select check box (Right Click on Check box) Prevent saving changes that require table re-creation like below click on Ok .



 Hope it will solve your problem still if you are facing the same problem comment on this article.

0 comments:

Post a Comment