connectseekers.com

Saturday, 28 March 2020

SQL Error : Saving Changes Is Not Permitted. The Changes You Have Made Require The Following Tables To Be Dropped And Recreated.

3/28/2020 - By Pranav Singh 0


This article will show you how you can prevent saving changes is not permitted, the changes you have made require the following tables to be dropped and recreated. So we will learn to remove or over come to this error.

First we will login to our sql server.




Now we will try to alter an already created table.



Now try to save the altered table . If you are getting below mention error.


On that case follow the steps and fix the issue

Step 1: Open SQL Server Management Studio

Step 2: From the file menu, choose Tools -> Options



Step 3: From the left menu, choose Designers


Step 4: Un-check the box entitled Prevent saving changes that require table re-creation


Step 5: Press OK to save the changes

Now try to save the table you will be able to save the table.




Thanks for reading the article please let me know you comment.





About the Author

We are the group of people who are expertise in different Microsoft technology like Asp.Net,MVC,C#.Net,VB.Net,Windows Application,WPF,jQuery,Javascript,HTML. This blog is designed to share the knowledge.

Get Updates

Subscribe to our e-mail newsletter to receive updates.

Share This Post

0 comments:

Please let me know your view

Free Ebooks


About Us

We are the group of people who are expertise in different Microsoft technology like Asp.Net,MVC,C#.Net,VB.Net,Windows Application,WPF,jQuery,Javascript,HTML. This blog is designed to share the knowledge.

Contact Us

For writing article in this website please send request by your

GMAIL ID: dotnetpools@gmail.com

Bugs and Suggestions

As we all know that this website is for sharing knowledge and providing proper solution. So while reading the article is you find any bug or if you have any suggestion please mail us at contact@aspdotnet-pools.com.

Partners


Global Classified : Connectseekers.com
© 2014 aspdotnet-pools.com Designed by Bloggertheme9.
back to top