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
Click image for larger version. 

Name:	Database Builder 18.2 - Missing Default values.png 
Views:	40 
Size:	56.9 KB 
ID:	13327

What would one do to restore the default values?

PS: My Development DB is SQL Express 2017 having the default values.