MSSQL db change identify specification not permit

Error when trying to modified the identity Yes to no  or no to yes

  1. Create a table, one column specified as primary key of integer type.
  2. Save the table.
  3. Open the table, set the primary key to be “Identity Specification = Yes”.
  4. 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?

 Print this Article

Also Read

I get "SQL Server does not exist or access is denied" error when I tried to connect to MS SQL database on your server?

This error indicates that Enterprise Manager or Query Analyzer cannot make a connection the...

How do I obtain the MS SQL database disk usage?

Execute this command in Sql Query Analyzer exec sp_spaceused The database size is measured in...

Cannot expand Databases in Management Studio

Error: Management Studio Express 2008 to access my shared hosted SQL 2005 / 2008 Standard. I...

Can I have more logins for my MS SQL database?

For old In House Control Panel : No. We only provide a single database user login. For...

I want to use a domain I already own, but do I have to transfer my domain name to you?

If you already own a domain name and you wish to use that domain name with a hosting account on...