sql server alter table add constraint with nocheck, and each email you receive will include easy unsubscribe options.