Issue
SQL Server Issue while modifying table through SQL Server Management Studio (SSMS).
When we alter the table definition, table design and try to save through SSMS, we get an error message saying "Saving Changes is not permitted."
Solution
1. Click on Tools Tab>> Options
2. Click on Designers
Un-check option "Prevent saving changes that requires re-creation."
That's it!!
Note: If you disable this option, you are not warned when you save the table that the changes that you made have changed the metadata structure of the table. In this case, data loss may occur when you save the table.
SQL Server Issue while modifying table through SQL Server Management Studio (SSMS).
When we alter the table definition, table design and try to save through SSMS, we get an error message saying "Saving Changes is not permitted."
Solution
1. Click on Tools Tab>> Options
Un-check option "Prevent saving changes that requires re-creation."
That's it!!
Note: If you disable this option, you are not warned when you save the table that the changes that you made have changed the metadata structure of the table. In this case, data loss may occur when you save the table.
No comments:
Post a Comment