Depending on how far you want to go. You could have an email table with the list of email addresses in it, then have a one to many relation...

Do not know your current architect, but I would disable anything that connects to the table under the hood(CDC, Replication, auditing) of that table has bitten me before when trying...

Not sure if this is what you are looking for.

The only thing I could think of is(keep in mind if the data type is not assign to a value the...