Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 mail server problem in SP

Author  Topic 

sqlhelp14
Yak Posting Veteran

55 Posts

Posted - 2008-01-30 : 14:59:57
while executing this sp_send_dbmail i am getting error...means my mail is queued..mail is sent..but not delivered....can u tell me anyone why??

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'WebSs',
@recipients = 'temp@copm.org',
@body = 'The stored procedure finished successfully.',
@subject = 'Automated Success Message'

can u tell me what's problem? how can i find mail server...

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2008-01-30T14:36:34). Exception Message: Could not connect to mail server. (No such host is known).
)

thanks

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-01-30 : 15:03:17
"Could not connect to mail server. (No such host is known)"

Seem like a likely reason.

CODO ERGO SUM
Go to Top of Page

sqlhelp14
Yak Posting Veteran

55 Posts

Posted - 2008-01-30 : 15:39:25
quote:
Originally posted by Michael Valentine Jones

"Could not connect to mail server. (No such host is known)"

Seem like a likely reason.

CODO ERGO SUM



mail server problem solved..now i can receive mails too..
Go to Top of Page
   

- Advertisement -