Post reply

sp_send_dbmail, encryption of email content

  • June 13, 2012 at 2:07 pm

    #392512

    I have not found a way to encrypt an email sent from SQL Server. I'm not talking about the actual transmission of the email. I want to encrypt the content of the email with my cert and and receive the email in outlook as an ecrypted email.

    In Unix, there is Mailx and we have a shell script written that we call from Oracle and it uses Mailx to encrypt the email.

    Does anyone have a Windows solution or a SQL Server solution for encrypting the content of email sent from SQL Server? It would not include such things as PGP or PKZIP.

  • June 13, 2012 at 2:11 pm

    #1500675

    Have you tried EncryptByCert ?

    http://technet.microsoft.com/en-us/library/ms188061


    Clear Sky SQL
    My Blog[/url]

  • June 13, 2012 at 2:17 pm

    #1500678

    I like your idea, encrypt the results of the query that is then sent by sp_send_dbmail.

    I'll look into a solution involving both.

    Thanks you!

  • February 19, 2013 at 3:59 am

    #1589107

    Do you got the solution on this?

    Are you able to encrypt your email sent from database mail from SQL Server?

    I am having similar requirement and not finding a solution.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply