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