My environment currently has five SMTP configurations. Three of them (the destination hostnames/servers) are going away soon. Instead of having to find and update all the alerts that have actions that point to the retiring SMTP server(s), I'd like to run one update statement against the DB to update all the actions to use an approved SMTP server. Will I be able to do this with the following SQL statement? If not, then what would be the most pain free method of making this update?
UPDATE ActionsProperties
SET PropertyValue = 4
WHERE PropertyName='SmtpServerID' AND PropertyValue IN ('1', '2', '5')
