Wednesday, March 17, 2010

SQL Server 2008: Allow users to save design changes that require tables to be dropped and re-created

I discovered today that SQL Server 2008 wants to save me from myself.  While I appreciate the intent, I’m beyond salvation.  I prefer productivity.
Scenario:  I tried to disable null values for a column in our development database, but SQL Server warned me that saving changes will require tables to be dropped and re-created:
image
Luckily, there’s an easy option to put the user back in control: 
Tools > Options > Designers > Table and Database Designers > Prevent saving changes that require table re-creation
image
I unchecked the flag, and I was in control again. (Or, at least in control of this…)

0 comments: