Wednesday, April 11, 2012

Creating / generating a '.eml' file from SQL Server dbmail

Is it possible to generate .eml file from SQL Server dbmail? I running SQL Server 2008 R2.



I have a requirement to create an 'email sandbox' where email will be staged before being delivered to our SMTP server for delivery. This will allow application generated (and hopefully dbmail), email to be viewed and approved before final delivery. I can achieve this in .NET by specifying a 'pickupDirectoryLocation' property for a SmtpClient object.



Questions: is there a way I can do this with SQL Server generated email as well?



Thanks





No comments:

Post a Comment