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?
Microsoft does not distribute MS SQL client tools individually, they are bundled with MS SQL...
To change a collation of database use this statement. USE Tempdb GO ALTER DATABASE Pubs COLLATE...
To connect to your Microsoft SQL Server 2000 database using the Query Analyser, you will...
Error: Management Studio Express 2008 to access my shared hosted SQL 2005 / 2008 Standard. I...
This error indicates that Enterprise Manager or Query Analyzer cannot make a connection the...