Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:
SQL Server needs a name for the constraint regardless; it’s worth specifying it yourself.
We’re back with a new wrinkle in the story.