Advertisements

How to resolve “Saving changes is not permitted” Error In Sql


Introduction

In this article you will learn how to resolve “Saving changes is not permitted” in SQL. The following table  “Table_1” contain the student mark information. I want to change that column name “Subject” to “Mark”.

Step 1 : I have one table “Table_1” and it contain the student mark information.

1

Step 2 : Design View of “Table_1”.

2

Step 3 : Now I changed the “Subject” name as “Mark” and “varchar(50)” as “int”. It is throwing the exception “Saving changes is not permitted”.

3

Step 4 : Go to Tools, click Options… , Expand Designers , then click Table and Database Designers,

4

Step 5 : Remove checked in “Prevent saving changes that require table re-creation.” Click Ok.

5

Step 6 : Click Ok.

6

Step 7 : Out Put.

7

Summary

We learned how to resolve “Saving changes is not permitted” in SQL. I hope this article will be useful for beginners.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: