I created a table tbl_Candidate
, but I forgot to set the primary key to the table and I saved it without primary key.
Next time I'm going to set primary key in SQL Server 2008 Express, I get a message like I have to drop the table and recreate when I'm going to save the table with primary key changes.
This is the message that pops up when I'm trying to save changes in the table:
Saving changes is not permitted. The changes you have made require
that the following tables to dropped and recreate. You have either made
changes to the table that can't be recreate or enable the option
prevent saving changes that require the tables to be recreate
I'm logged into SQL Server with Windows authentication, server type as database engine and Server name as .\SQLExpress
.
Please give me a way to correct this problem or way to change the settings of the SQL Server.
Best Answer
The answer is on the MSDN site:
EDIT 1:
Additional useful informations from here: