Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

xp_sendmail not sending @message text Expand / Collapse
Author
Message
Posted Wednesday, July 13, 2011 10:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 4:19 PM
Points: 4, Visits: 58
xp_sendmail will send out the email with correct to address, correct subject line but the message text is blank. This has been working.
We were just migrated to Exchange 2010.
We have ran xp_stopmail, recreated outlook profile and SQL mail profile, then ran xp_startmail.


We are out of ideas. Any help will be greatly appreciated.

Thanks
Jack
Post #1141143
Posted Wednesday, July 13, 2011 10:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:24 AM
Points: 12,744, Visits: 31,069
are you concatenating strings, and one of them is null?
you know the old SET @string = Firstname + ' ' + LastName,
where ofirstname might be null or something?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1141149
Posted Wednesday, July 13, 2011 10:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 4:19 PM
Points: 4, Visits: 58
Running this through query sends email with no message. to line and subj line are fine.

EXEC master.dbo.xp_sendmail @recipients = 'jm7563@att.com',
@message = 'test message',
@subject = 'Peer One Salary Recommendation Alert'
Post #1141153
Posted Thursday, August 18, 2011 9:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 06, 2012 2:34 PM
Points: 2, Visits: 14
Just kicking to the top. We still need an answer to this issue.
Post #1161844
Posted Wednesday, February 29, 2012 11:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 7:13 AM
Points: 1,634, Visits: 1,964
I'm running into this too. In my case it's an existing process on a SQL 2000 SP4 box that started erroring sending mail (no error messages that appear useful). I stopped then started the mail session and mail started sending but the message body is always blank even when passing in a normal string. The goal is to email query results in the message body. I'm able to attach them and we're doing that for now as a workaround. I've already tried the following:
http://support.microsoft.com/kb/314304

The registry key that it said to remove doesn't exist and I tried both true and false (and not passing in) @ansi_attachments with no success. It's a production box so I'm working on arranging a reboot but I'm not holding much hope for that. Does anyone have any thoughts?
Post #1259752
Posted Thursday, March 01, 2012 1:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 06, 2012 2:34 PM
Points: 2, Visits: 14
We believe the issue is how MS SQL 2000's SQL Mail interacts with the newest version of MS Exchange Server (our problem started when the Exchange server was updated).

I found an addin function, xp_smtp_sendmail, that fixes the problem.
Go to: http://www.sqlservercentral.com/Forums/FindPost320477.aspx
Post #1260411
Posted Friday, March 02, 2012 7:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 7:13 AM
Points: 1,634, Visits: 1,964
That's probably what did it for us. I found out that they did some mailbox moves this week and the account is currently on the new server. The tech that did the moves is out so I haven't been able to confirm that this mailbox moved but it seems to be the most likely case.

As a note, the link to the package in the other post is broken. We have a copy I can use from another server though.
Post #1260801
Posted Monday, January 07, 2013 9:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 2:17 PM
Points: 8, Visits: 65
I am having this same issue. I use the same email account on 2 SQL 2000 servers. Everything works great on one of hte servers, but the @message is not being sent on the other server. I have verified that everything is set up the same on both servers. Any ideas?
Post #1403718
Posted Monday, March 11, 2013 8:46 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 15, 2013 9:03 AM
Points: 55, Visits: 355
I too am running into this with SQL Server 2008 R2 at the moment.

I'm getting a subject line, no body text. Still plugging away at it. If I get it running, I'll post what I did to get it running.

Until then, if anyone has a fix, please elaborate.

Thanks!





======================================================
John
SQL Server 200x Newb and proud of it!
======================================================
Post #1429310
Posted Monday, March 11, 2013 9:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:56 AM
Points: 221, Visits: 306
John Waclawski (3/11/2013)
I too am running into this with SQL Server 2008 R2 at the moment.

I'm getting a subject line, no body text. Still plugging away at it. If I get it running, I'll post what I did to get it running.

Until then, if anyone has a fix, please elaborate.

Thanks!





Here is a piece of code i use for sending mail in SQL Server 2008 R2:

EXEC msdb.dbo.SP_SEND_DBMAIL @PROFILE_NAME = 'Your Profile Here',
@Recipients ='test@email.com',
@Subject = 'Subject Line',
@body = 'Your Message Here'

This article gives you step by step to setup db mail if you have not done so already:

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
Post #1429326
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse