I have recently upgraded my main office server. In the process we also upgraded from SQL Express 2008 to SQL Express 2017.
Everything seem to have worked just fine, until the other day when I went to apply my changes from Development to Production environment.
After making a change to the table, I received an error message that the table cannot save an empty value in a required field.
When I opened DBBuilder, I noticed, that all values in the "Default" column are empty.... On ALL Tables. see picture
What would one do to restore the default values?
PS: My Development DB is SQL Express 2017 having the default values.