Mail sending problem from sql server

Question

I have configured the mail in SQL Server but when I am sending mail from SQL Server it is showing mail queue message but I am not getting the mail. I also grant the permission to msdb.dbo.sp_send_dbmail sp for public.

my mail sending code as follows.

EXEC msdb.dbo.sp_send_dbmail @recipients='[email protected]',            
@subject = 'test',            
@body = 'Test',            
@body_format = 'HTML';

I just do not understand why I am not getting mail where as I am getting mail queue message when sending.

please guide me.

thanks

If you post code or XML, please highlight those lines in the text editor and click on the "code" button (101 010) on the editor toolbar to nicely format and syntax highlight it! — marc_s
– marc_s, Commented Nov 23, 2010 at 13:11

Roni Vered · Accepted Answer · 2010-11-23 13:13:51Z

1

Right click database mail (In the Management tree) and choose View Database mail log. You can see there the errors regarding the mail sent.

Can you post the errors you see in the log ?

answered Nov 23, 2010 at 13:13

Roni Vered

7872 gold badges8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mail sending problem from sql server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related