BowieRules! (12/2/2010)
I am sorry for confusing you with insert option, I only included it here because I found it on another blog as a solution to the problem, which I agree is not really a solution, but still a valid workaround, especially if it is put in a good InsertUpdate stored procedure.
This is not an administrative workaround and will not enforce the contraint from a DBA perspective.
It would not pass an Audit either. The other solutions listed would.
:cool:I am giong to get my point I lost back!;-)