SQL Server 2008 ERROR: Saving changes are not permitted. The Changes you have made require the following tables to be dropped and re-created.

Introduction

Here I will explain how to solve problem in SQL Server 2008 Saving changes are not permitted.

Description

 I installed SQL Server 2008 and I created one new database after that I created one table and saved it everything working fine again I opened newly created table to change column name previously I entered wrong name again I changed column name and if I am trying to save that modifications I got error like this

After that I have changed some of options to rectify this error in SQL Server 2008

Follow these steps to solve this problem 

1)    1) Open SQL Server Management Studio

2)    2) Go to Tools

3)    3) In that go to Options

4)    4) In leftside treeview select Designers

5)    5) In Designers select Table and Designers

6)    6) After that in right side “Uncheck” check box of Prevent saving changes that require table re-creation.

Now modify your table and save it now that table will save successfully into your database

Happy coding……

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email