Andy Levy is looking for a name:
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.
Read on for an interesting scenario where Andy very clearly named a constraint, yet the name didn’t take.