sp_send_dbmail problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » sp_send_dbmail problem

sp_send_dbmail problem

Rate Topic

Display Mode

Topic Options

Author

Message

Mischa E.J. Hoogendoorn

Posted Thursday, October 25, 2012 3:41 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 15, 2013 5:07 AM
Points: 21, Visits: 87

Hello,

I've got a very strange problem, I can send mail with the following statement:

declare @Error int

EXEC @Error = msdb.dbo.sp_send_dbmail
@profile_name = 'SQL Mail',
@recipients='<mymailaddress>',
@subject = 'Database Mail Test',
@body = 'This is a test e-mail sent from Database Mail on <server>\<instance>',
@body_format = 'Text' ;

select @Error

When I change the subject or body, the mail will not be send?!

How can this happen?

Thanks for your reply...

Greetings Mischa.

Post #1376870

Bhuvnesh

Posted Thursday, October 25, 2012 3:49 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

can you post the complete changed database mail SP call you are using.

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1376873

Fatherjack

Posted Thursday, October 25, 2012 4:18 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 23, 2013 12:53 PM
Points: 273, Visits: 451

What error message do you get?

Post #1376889

Mischa E.J. Hoogendoorn

Posted Thursday, October 25, 2012 4:37 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 15, 2013 5:07 AM
Points: 21, Visits: 87

Thanks for the replies! I have the solution, mail was not configured completely. Run this script:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO

Problem solved! I just do not understand why the test message is sending correctly when these options are not set...

Best regards,

Mischa

Post #1376898

Bhuvnesh

Posted Thursday, October 25, 2012 4:40 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Mischa E.J. Hoogendoorn (10/25/2012)

I just do not understand why the test message is sending correctly when these options are not set...

i stil dont believe this , if the mail was not configurd , msgs cant be sent w00t

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1376905

Mischa E.J. Hoogendoorn

Posted Thursday, October 25, 2012 4:48 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 15, 2013 5:07 AM
Points: 21, Visits: 87

I just tried it, and it worked... Same server, nothing else changed, except for a reboot.

Best regards,

Mischa

Post #1376908

« Prev Topic | Next Topic »

Permissions