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 Fix
On 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:
Was this answer helpful?
This error indicates that Enterprise Manager or Query Analyzer cannot make a connection the...
Execute this command in Sql Query Analyzer exec sp_spaceused The database size is measured in...
Error: Management Studio Express 2008 to access my shared hosted SQL 2005 / 2008 Standard. I...
For old In House Control Panel : No. We only provide a single database user login. For...
If you already own a domain name and you wish to use that domain name with a hosting account on...