Wednesday, March 7, 2012

msdb.dbo.sp_send_dbmail error

I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this

EXEC msdb.dbo.sp_send_dbmail

@.profile_name = 'saly',

@.recipients = @.email,

@.subject = @.subject,

@.body = @.body;

Go

And when EXEC it gives me mail qeue

and mail don't arrive where it goes i don't know please tell me what error

thankx very much

Check the mail log.

Have you start the smtp service

|||

hi

have the same promlem

and I have tried so many solutions.If u foud how to do so please tell me .

thanks

|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.
Tim

No comments:

Post a Comment