After moving alert(s) from one folder to another, SMTP recipient settings are lost, and the following insert statement error occurs attempting to re-enable the desired settings:
SQL error(-2146232060): Error: 547, Procedure: usp_QueryAlertMail_Write, Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_QueryAlertMail_QueryAlert". The conflict occurred in database "ChangeAuditor", table "Query.Def", column 'QueryID'.;
Corrupted Alert settings and/or Search
Recreate the Search like this:
1. Create a copy of the alert-enabled search. Find the expected recipient settings will be restored.
2. Delete the original broken alert-enabled search.
