notification_email_address is a bit of a weird one.
The value is never sanity checked by SQL Server when used, and it silently truncates it to a maximum of 100 characters, leading to some unwanted side effects such as malformed email address(es)!
Technically speaking this can use a semi-colon delimited list of addresses, so long as the total length is less than 100 characters. However it is more commonly used for a single email address value (hence the name being a singleton).
As a minimum I want it to be validated such that:
An exception is thrown if the value is longer than 100 characters
Nice to haves:
Throw an exception if the string is too short
Throw an exception if the value (or values if semi-colon delimited) don't look like valid email addresses (which might trump the previous rule)
notification_email_address
is a bit of a weird one.The value is never sanity checked by SQL Server when used, and it silently truncates it to a maximum of 100 characters, leading to some unwanted side effects such as malformed email address(es)!
Technically speaking this can use a semi-colon delimited list of addresses, so long as the total length is less than 100 characters. However it is more commonly used for a single email address value (hence the name being a singleton).
As a minimum I want it to be validated such that:
Nice to haves: