SQL Server Error - When We Want To Add Any Field To Table

An error occurs in the SQL Server whenever we use the create database, or whenever we try to save the code. Let's see how to solve this issue.

The following error occurs in the SQL Server whenever we use the create database, or whenever we try to save the code.

This error occurs because whenever we want to add any field to the table, it is not able to give the permission to add new changes to the table. The above error occurs only when you want to add new files to the existing record.

Now I will tell you how to solve this error.

Step 1: Go to the Tool Menu in the Menu bar and select Option.

 

Step 2: Then, go to Designers -> Table and Database Designers.

 

Step 3: Then see whether the CheckBox of "Prevent saving changes that require table re-creation" is checked.

Step 4: Now uncheck the checked box.

Step 5: Click on OK.

Step 6: Now try to save the table; you will see that it will not show the above error and it will save your changes.

For more articles, visit my blog:

dotnetbyabhipatil