Saving Changes is not Permitted in SQL
The issues came when a user tried to save the table using SSMS.
Like you are changing column Name or allowing NULLS or anychange in a table from Design mode.
Below is the Error when saving the Changes.
Right click table-Design -Trying to change column Name
Below is the Solution of above Issue.
Go to Top Menu Bar
Tools
Options
Open Designers(Right Hand Side)
Table and Database designs
Uncheck the Box-Prevent Saving Changes that require table re-creation
click ok
Screenshot
Save the table or press ctrl S to save the table.
The table will save with all the changes made in the table.
NOTE: The above steps are same for sql 2005,sql 2008 and sql 2012.
NOTE: The above steps are same for sql 2005,sql 2008 and sql 2012.
No comments:
Post a Comment