Friday, December 19, 2008

SQL Server 2008 Error

I downloaded and installed the SQL Server 2008 Express on my home computer and was testing it out. I created a test database and a test table in it. Then, in design view I was adding columns to this table. When I hit the save for the first time, I was prompted for a table name. I gave this table a name. After the table was named and created, I wanted to add a new column to it. But every time I was trying to save this table I was getting the following annoying error.

"Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created."

Here is the screenshot.

The solution of this problem is to go to Tools -> Options -> Designers -> Table and Database Designers and uncheck the "Prevent saving changes that require table re-creation".

Here is how to solve it: