Mixing
![New Grad handling job offer while interviewing with other companies [duplicate]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjbpfN9tAutmK93bJRC3ZoROZzi2TJDms5n8_qJuhgE0a9b52OOHayv3NGT8igAdFL7byXNst-_1DZK5SjrIJ28_6RQPUpBROqMs5s6jo-ZsjX8kjDwfxJufIitH3TaQRXWaGSQKRQib-f/s72-c/1.jpg)
How to send secure emails using sp_send_dbmail
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
3
down vote
favorite
When using sp_send_dbmail to send an email on SQL Server, how do you specify that the email be sent in an encrypted format?
I found a thread discussing including the string "[SECURE]" in the subject line, but these comments are 8 years old and not backed up by any source.
sql-server sql-server-2012 security encryption database-mail
edited 3 hours ago
Tom V
13.1k74373
asked 4 hours ago
ukemi
1162
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
3
down vote
favorite
When using sp_send_dbmail to send an email on SQL Server, how do you specify that the email be sent in an encrypted format?
I found a thread discussing including the string "[SECURE]" in the subject line, but these comments are 8 years old and not backed up by any source.
sql-server sql-server-2012 security encryption database-mail
edited 3 hours ago
Tom V
13.1k74373
asked 4 hours ago
ukemi
1162
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4
How do you define secure? How do you want to encrypt it? PGP? It looks like the thread you linked to refers to an exchange plugin where a keyword in a subject makes sure the email is rewritten and shown in a web app
– Tom V
3 hours ago
@TomV In (for example) Outlook, there is an option to encrypt (apparently using DES) an outgoing email before it is sent. Is there a way to trigger this functionality from the parameters passed tosp_send_dbmail?
– ukemi
2 hours ago
1
Maybe if you have the public key you can encrypt the body of the message yourself before sending it, I'm not sure which parts are encrypted and which are not by outlook. I have never done this though. As email from sp_send_dbmail is not sent through outlook I don't think you can piggy-back on the outlook functionality
– Tom V
2 hours ago
add a comment |Â
up vote
3
down vote
favorite
up vote
3
down vote
favorite
When using sp_send_dbmail to send an email on SQL Server, how do you specify that the email be sent in an encrypted format?
I found a thread discussing including the string "[SECURE]" in the subject line, but these comments are 8 years old and not backed up by any source.
sql-server sql-server-2012 security encryption database-mail
edited 3 hours ago
Tom V
13.1k74373
asked 4 hours ago
ukemi
1162
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
When using sp_send_dbmail to send an email on SQL Server, how do you specify that the email be sent in an encrypted format?
I found a thread discussing including the string "[SECURE]" in the subject line, but these comments are 8 years old and not backed up by any source.
sql-server sql-server-2012 security encryption database-mail
sql-server sql-server-2012 security encryption database-mail
edited 3 hours ago
Tom V
13.1k74373
asked 4 hours ago
ukemi
1162
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 3 hours ago
Tom V
13.1k74373
asked 4 hours ago
ukemi
1162
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 3 hours ago
Tom V
13.1k74373
edited 3 hours ago
Tom V
13.1k74373
edited 3 hours ago
Tom V
13.1k74373
13.1k74373
asked 4 hours ago
ukemi
1162
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
ukemi
1162
asked 4 hours ago
ukemi
1162
1162
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
ukemi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4
How do you define secure? How do you want to encrypt it? PGP? It looks like the thread you linked to refers to an exchange plugin where a keyword in a subject makes sure the email is rewritten and shown in a web app
– Tom V
3 hours ago
@TomV In (for example) Outlook, there is an option to encrypt (apparently using DES) an outgoing email before it is sent. Is there a way to trigger this functionality from the parameters passed tosp_send_dbmail?
– ukemi
2 hours ago
1
Maybe if you have the public key you can encrypt the body of the message yourself before sending it, I'm not sure which parts are encrypted and which are not by outlook. I have never done this though. As email from sp_send_dbmail is not sent through outlook I don't think you can piggy-back on the outlook functionality
– Tom V
2 hours ago
add a comment |Â
4
How do you define secure? How do you want to encrypt it? PGP? It looks like the thread you linked to refers to an exchange plugin where a keyword in a subject makes sure the email is rewritten and shown in a web app
– Tom V
3 hours ago
@TomV In (for example) Outlook, there is an option to encrypt (apparently using DES) an outgoing email before it is sent. Is there a way to trigger this functionality from the parameters passed tosp_send_dbmail?
– ukemi
2 hours ago
1
Maybe if you have the public key you can encrypt the body of the message yourself before sending it, I'm not sure which parts are encrypted and which are not by outlook. I have never done this though. As email from sp_send_dbmail is not sent through outlook I don't think you can piggy-back on the outlook functionality
– Tom V
2 hours ago
4
4
How do you define secure? How do you want to encrypt it? PGP? It looks like the thread you linked to refers to an exchange plugin where a keyword in a subject makes sure the email is rewritten and shown in a web app
– Tom V
3 hours ago
How do you define secure? How do you want to encrypt it? PGP? It looks like the thread you linked to refers to an exchange plugin where a keyword in a subject makes sure the email is rewritten and shown in a web app
– Tom V
3 hours ago
@TomV In (for example) Outlook, there is an option to encrypt (apparently using DES) an outgoing email before it is sent. Is there a way to trigger this functionality from the parameters passed to
sp_send_dbmail?– ukemi
2 hours ago
@TomV In (for example) Outlook, there is an option to encrypt (apparently using DES) an outgoing email before it is sent. Is there a way to trigger this functionality from the parameters passed to
sp_send_dbmail?– ukemi
2 hours ago
1
1
Maybe if you have the public key you can encrypt the body of the message yourself before sending it, I'm not sure which parts are encrypted and which are not by outlook. I have never done this though. As email from sp_send_dbmail is not sent through outlook I don't think you can piggy-back on the outlook functionality
– Tom V
2 hours ago
Maybe if you have the public key you can encrypt the body of the message yourself before sending it, I'm not sure which parts are encrypted and which are not by outlook. I have never done this though. As email from sp_send_dbmail is not sent through outlook I don't think you can piggy-back on the outlook functionality
– Tom V
2 hours ago
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
3
down vote
I don't think SQL Server has any built-in functionality to achieve what you're after.
One possible solution is to use a local SMTP server as a relay, so that the email is not encrypted on the initial hop (between SQL Server and the local SMTP server), but it gets encrypted leveraging the SMTP server's functionalities on the second hop (to the outbound SMTP server).
answered 2 hours ago
spaghettidba
9,6371835
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
3
down vote
I don't think SQL Server has any built-in functionality to achieve what you're after.
One possible solution is to use a local SMTP server as a relay, so that the email is not encrypted on the initial hop (between SQL Server and the local SMTP server), but it gets encrypted leveraging the SMTP server's functionalities on the second hop (to the outbound SMTP server).
answered 2 hours ago
spaghettidba
9,6371835
add a comment |Â
up vote
3
down vote
I don't think SQL Server has any built-in functionality to achieve what you're after.
One possible solution is to use a local SMTP server as a relay, so that the email is not encrypted on the initial hop (between SQL Server and the local SMTP server), but it gets encrypted leveraging the SMTP server's functionalities on the second hop (to the outbound SMTP server).
answered 2 hours ago
spaghettidba
9,6371835
add a comment |Â
up vote
3
down vote
up vote
3
down vote
I don't think SQL Server has any built-in functionality to achieve what you're after.
One possible solution is to use a local SMTP server as a relay, so that the email is not encrypted on the initial hop (between SQL Server and the local SMTP server), but it gets encrypted leveraging the SMTP server's functionalities on the second hop (to the outbound SMTP server).
answered 2 hours ago
spaghettidba
9,6371835
I don't think SQL Server has any built-in functionality to achieve what you're after.
One possible solution is to use a local SMTP server as a relay, so that the email is not encrypted on the initial hop (between SQL Server and the local SMTP server), but it gets encrypted leveraging the SMTP server's functionalities on the second hop (to the outbound SMTP server).
answered 2 hours ago
spaghettidba
9,6371835
answered 2 hours ago
spaghettidba
9,6371835
answered 2 hours ago
spaghettidba
9,6371835
answered 2 hours ago
spaghettidba
9,6371835
9,6371835
add a comment |Â
add a comment |Â
ukemi is a new contributor. Be nice, and check out our Code of Conduct.
ukemi is a new contributor. Be nice, and check out our Code of Conduct.
ukemi is a new contributor. Be nice, and check out our Code of Conduct.
ukemi is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f219061%2fhow-to-send-secure-emails-using-sp-send-dbmail%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
4
How do you define secure? How do you want to encrypt it? PGP? It looks like the thread you linked to refers to an exchange plugin where a keyword in a subject makes sure the email is rewritten and shown in a web app
– Tom V
3 hours ago
@TomV In (for example) Outlook, there is an option to encrypt (apparently using DES) an outgoing email before it is sent. Is there a way to trigger this functionality from the parameters passed to
sp_send_dbmail?– ukemi
2 hours ago
1
Maybe if you have the public key you can encrypt the body of the message yourself before sending it, I'm not sure which parts are encrypted and which are not by outlook. I have never done this though. As email from sp_send_dbmail is not sent through outlook I don't think you can piggy-back on the outlook functionality
– Tom V
2 hours ago