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:
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
I unchecked the flag, and I was in control again. (Or, at least in control of this…)
0 comments:
Post a Comment