Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
This article provides information on how to change the SMTP server name using the Advanced Rules option without going through the properties of each rule.
NPM v11.5.2 and earlier versions
There are three different ways to change the SMTP server name:
declare @oldServerName As Varchar(255) declare @newServerName As Varchar(255) set @oldServerName = 'OLD_SERVER_NAME' set @newServerName = 'NEW_SERVER_NAME' update [dbo].[ActionDefinitions] set [Target] = REPLACE(CAST( [Target] AS VARCHAR(MAX)),'SMTPSERVER:'+@oldServerName,'SMTPSERVER:'+@newServerName) WHERE Target like '%SMTPSERVER:%'
Replace OLD_SERVER_NAME with the hostname or IP address of your old SMTP server
Replace NEW_SERVER_NAME with the host name or IP address of your new SMTP server
select * from [ActionDefinitions]