MSSQL db change identify specification not permit
Error when trying to modified the identity Yes to no or no to yes
- Create a table, one column specified as primary key of integer type.
- Save the table.
- Open the table, set the primary key to be “Identity Specification = Yes”.
- Save the modified table.
“Saving changes is not permitted. The changes you have made…. …. or enabled the option Prevent saving changes that require…“, [Cancel] [Save Text File].
The error look like this
In order to FixOn the Tools menu in Management Studio:
Options… -> Designers and uncheck “Prevent saving changes that require table re-creation“.This is the check box to look for: