I have added a column to a table in SQL Server 2005. When I attempt to save it, I get this message:
Saving changes is not permitted. The change 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.
The column I added was nothing special, a nullable nvarchar(11) with no index or constraints. I have never seen this problem before, and have changed the table many times earlier.
Anyone know what's going on, and where I should look for the mentioned option?