After moving alert(s) from one folder to another SMTP recipients 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'.;
WORKAROUND
1. Create a copy the alert-enabled search. Find the expected recipient settings will be restored.
2. Delete the original broken alert-enabled search.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center