Divert all emails from all users?

Question

Any way to divert all email bound for real users to a fake/test email. We just had a flood of emails go out on a test import. But we would like to be able to see the emails the system wants to send. Not just turn the whole thing off.

Steven Heffner · Accepted Answer

Assuming this happened on a test instance, probably the best way to prevent emails to real addresses is to run the following scrub script on your test db: update dbo.aspnet_Membership set Email = email + '.bounce', LoweredEmail = LoweredEmail + '.bounce', PasswordFormat = 0,Password ='password' update dbo.cs_Users set Email = Email + '.bounce' update dbo.cs_SiteSettings set SettingsXML = REPLACE(CAST(SettingsXML AS NVARCHAR(MAX)),'[YOUR SMTP SERVER ADDRESS]', '127.0.0.1') update dbo.cs_SiteSettings set SettingsXML = REPLACE(CAST(SettingsXML AS NVARCHAR(MAX)),'true', 'false') update dbo.cs_SiteSettings set SettingsXML = REPLACE(CAST(SettingsXML AS NVARCHAR(MAX)),'true', 'false') update dbo.cs_SiteSettings set SettingsXML = REPLACE(CAST(SettingsXML AS NVARCHAR(MAX)),'true', 'false') update dbo.cs_SiteSettings set SettingsXML = REPLACE(CAST(SettingsXML AS NVARCHAR(MAX)),'587', '') This should prevent real emails from being sent out. Just make sure this is a backup/test instance of the db.

Divert all emails from all users?

Top Replies