Errors were Encountered During Save Process, Some Database Objects were not Saved

Errors were Encountered During Save Process, Some Database Objects were not Saved

In this post we will discuss about error: Errors were Encountered During Save Process, Some Database Objects were not Saved. Recently i have tried to add a new column to a existing table.But i have got following error: Errors were Encountered During Save Process, Some Database Objects were not Saved.

At last i got to know that following error is due to: When we want try to add any field to table then it will not give the permission to add new changes to the table.the above error is occurred only when u want to add new filed to the existing record.

On last post we have discussed about How to Find Recently Executed Queries in SQL Server Database.

Save Text File in SQL Server

To solve this issue follow these simple steps:

1. Click on Tools > Click on Options.

2. Go to Designers > Table and Database Designers.

3. Then uncheck checkbox Prevent saving changes that require table re-creation.
Errors were Encountered During Save Process, Some Database Objects were not Saved