<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Database Mail Reply To account
36 posts, Page 1 of 4
1
2
3
4
»
»»
Database Mail Reply To account
Rate Topic
Display Mode
Topic Options
Author
Message
Jack Corbett
Jack Corbett
Posted Wednesday, March 19, 2008 8:00 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 7:03 PM
Points: 8,178,
Visits: 7,953
I have setup database mail and can send email using it. I added a reply to account to the DBMail account and assumed when I reply to the SQL generated email I would see the reply go to the Reply To account. But, alas, it only is returned to the sending email account. When I look at sp_send_dbmail, I do not see a Reply To parameter. Having found this I am forced to assume that MS never actually implemented the Reply To functionality. Has anyone else tried this? If you have, had you had success?
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #471578
Todd Engen
Todd Engen
Posted Wednesday, March 19, 2008 6:29 PM
SSC Eights!
Group: General Forum Members
Last Login: Monday, March 15, 2010 3:05 PM
Points: 970,
Visits: 5,832
Can only confirm what you're seeing.
Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.
From looking at a packet capture of the SMTP traffic, 'Reply-To:' was nowhere to be found in the message body.
This issue at connect.microsoft.com appears similar and is still open for feedback:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=264498
Post #472022
Jack Corbett
Jack Corbett
Posted Wednesday, March 19, 2008 10:00 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 7:03 PM
Points: 8,178,
Visits: 7,953
Thanks for the confirmation Todd. I did a quick google and did not find anything so I made this quick post hoping someone would have a little more information. I have only been working with 2005 for a few months so I thought someone would have seen this.
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472050
Joe Clifford
Joe Clifford
Posted Thursday, March 20, 2008 10:41 PM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, December 25, 2009 2:21 PM
Points: 422,
Visits: 542
You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on the list of valid email addresses of the sending account - dependent on relay-settings as well.
Joe
Post #472671
Lynn Pettis
Lynn Pettis
Posted Friday, March 21, 2008 8:11 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 11,906,
Visits: 11,989
Interesting. I have a reply-to address setup for my Database Mail profiles and it seems to work just fine. I'd be interested in hear what you find in regard to this problem.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #472822
Jack Corbett
Jack Corbett
Posted Friday, March 21, 2008 8:28 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 7:03 PM
Points: 8,178,
Visits: 7,953
Joe Clifford (3/20/2008)
You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on the list of valid email addresses of the sending account - dependent on relay-settings as well.
Joe
Yes we are using Exchange. I'll try it using gmail.
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472842
Jack Corbett
Jack Corbett
Posted Friday, March 21, 2008 8:59 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 7:03 PM
Points: 8,178,
Visits: 7,953
A quick update. I switched to using gmail as the smtp server and still no joy on the Reply To setting.
Lynn,
What mail server are using for SMTP? I am on SQL 2005 64-bit SP2. Any differences with your setup? I have tried our local exchange server and gmail now.
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472870
Adam Bean
Adam Bean
Posted Friday, March 21, 2008 9:17 AM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, March 09, 2010 11:06 AM
Points: 951,
Visits: 1,329
My reply to works just fine ... curious to hear what you find out ... Anything you'd like me to find out from our exchange guy?
It is not enough to succeed. Others must fail.
SQLSlayer.com
Post #472886
Jack Corbett
Jack Corbett
Posted Friday, March 21, 2008 9:22 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 7:03 PM
Points: 8,178,
Visits: 7,953
Todd Engen (3/19/2008)
Can only confirm what you're seeing.
Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.
From looking at a packet capture of the SMTP traffic, 'Reply-To:' was nowhere to be found in the message body.
This issue at connect.microsoft.com appears similar and is still open for feedback:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=264498
Adam,
Did you check out the link Todd posted? I did and it seems that it is a bug. Are you using 32 or 64-bit SQL? I am using 64-bit. I will try it on the 32-bit version I am running on my desktop to see if that may be the issue.
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #472891
Adam Bean
Adam Bean
Posted Friday, March 21, 2008 9:28 AM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, March 09, 2010 11:06 AM
Points: 951,
Visits: 1,329
Well, I'll be damned ... I wasn't looking at it properly due to the email address being a group ...
Anyways, both in x86 and x64, I changed the replyto email, and when I reply, it is in fact using the sender in the reply to.
Just tried it in the latest CTP of 2008, and the same problem resides. So now more than ever I'm curious to as what is causing this.
It is not enough to succeed. Others must fail.
SQLSlayer.com
Post #472901
« Prev Topic
|
Next Topic »
36 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
