These SQL scripts will search and replace ALERT DEFINITION email addresses.

Example:  original orion admin leaves and you take position.  you need to change all alerts from their email to yours.

read comments...ensure you update email addresses prior to executing AND BACKUP YOUR DATABASE FIRST!!!

test-update_actionDefinitions email addresses.sql   and

update_actionDefinitions email addresses

test.... allows you to see results of query

update... actually makes the changes

I'd recommend (per comments) you select a row to test from first script and grab the ActionDefID and replace in the where clause.