Geek asks and answers

Creating / generating .eml file from SQL Server dbmail

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

I have a requirement to create a sandbox for email, where email will be delivered before delivery to our SMTP server for delivery. This will allow you to create applications (and, hopefully, dbmail), send emails for review and approval before final delivery. I can achieve this in .NET by specifying the pickupDirectoryLocation property for the object SmtpClient.

Questions: is there a way to do this using email with SQL Server?

thank

+3
source share
1 answer

Good question! I never thought about that.

, proc_dbmail, . , Database Mail (DatabaseMail.exe), .

, , , :

  • sysmail_configure_sp AccountRetryDelay DatabaseMailExeMinimumLifeTime ( , ), , ( / ). , . .

  • , , send_dbmail

+1

More articles:


All Articles