SQL Server 2008 Save Not Permitted Dialog Box
6/3/2009 12:49:46 AM
I was creating some tables this evening in a SQL Server 2008 database this evening so that I could sandbox some MVC functionality for a current project. I had designed the tables according to the tutorial only to find out that this wasn't the case. I'll just log back in to SQL and make the necessary changes. Easy.
When I added the missing column I went ahead and reordered to match the same order of the tutorial because, well; I am a little OCD at times. I remember doing this in the past pre-SQL 2008 with no trouble. This time I was hit with this:
Weird. Again, I had never seen this before so I was a bit surprised.
According to SQL Server 2008 Books Online this can be caused by any of the following:
- Adding a new column to the middle of the table
- Dropping a column
- Changing column nullability
- Changing the order of the columns
- Changing the data type of a column
Really? These all seem like fairly common tasks when working within a database. As odd as this may seem (maybe there is a good reason for this?), there is a very easy fix.
From the Tools menu click on Options, expand Designers, click on Table and Database Designers. Select or clear the Prevent saving changes that require table re-creation option.
Much better. Back to work.
Database,
SQL
Comments
Prevent saving changes that require table re-creation option.
Posted by: vancl | 10/2/2009 6:04:32 AM