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.