yeah, I should have said unique constraint.

Nope, not joking. Actually, it's pretty common - in my 12 years doing this stuff anyways. I didn't invent the concept. You might want to do some...

A surrogate key is meaningless by itself, it's just a GUID or Identity. You also need the unique key to inforce the natural key/s relationship in the table.

I agree with Quazibubbles post as well. The surrogate primary key needs to be paired with a unique key in order to maintain data integrity. This concept seems...

Another benefit of using the built in sp_publication_validation or sp_article_validation stored procs is that if the validation fails during execution, it will raise an error to the application log. ...