开发者

Mail sending problem from sql server

I have configured the mail in SQL Server but when I am sending mail from SQL Server it is showing mail qu开发者_开发技巧eue 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='test@bba-reman.com',            
@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


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 ?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜