Tools > Options... > Designers holds a checkbox for "Prevent saving changes that require table re-creation" that you may uncheck in SSMS2014 to allow for saving a table when you uncheck an "allows null" checkbox when editing a column. Obviously, you can't make this happen until you've first gotten rid of all nulls in that column.
No comments:
Post a Comment