Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
SQL server SMTP mailI am configuring SMTP mail on my SQL servers. I added all my pop3 account infiormation. When i am sending an email using xp_sendmail, xp_send amil was successfull, I am not getting messages. Then i stopped the mail services and I opened outlook all these messages are in the out look there are not trasfered to to my email. any idia , what 's going on, how can i resolve thi s issue. -- SQL serer DBA
Post Follow-up to this message
Re: SQL server SMTP mailThe e-mail is going to go into the outbox in the mail profile defined on the SQL Server. They will only be sent if Outlook is open and automatically sending messages. This was one of the main reason that SQLMail was eliminated from SQL Server 2005 and replaced with Database Mail which is a pure SMTP client. -- Mike Mentor Solid Quality Learning http://www. solidqualitylearning .com "Srikanth" < Srikanth@discussions .microsoft.com> wrote in message news:2E86C672-22C4-4988-A3B6- 125EDA5E396B@microso ft.com... >I am configuring SMTP mail on my SQL servers. I added all my pop3 account > infiormation. When i am sending an email using xp_sendmail, xp_send amil > was > successfull, I am not getting messages. Then i stopped the mail services > and > I opened outlook all these messages are in the out look there are not > trasfered to to my email. any idia , what 's going on, how can i resolve > this > issue. > -- > SQL serer DBA
Post Follow-up to this message Re: SQL server SMTP mailHi You may want to read http://support.microsoft.com/kb/263556/ Rather than relying on outlook you can use XPSMTP http://www.sqldev.net/xp/xpsmtp.htm as an alternative. John "Srikanth" < Srikanth@discussions .microsoft.com> wrote in message news:2E86C672-22C4-4988-A3B6- 125EDA5E396B@microso ft.com... >I am configuring SMTP mail on my SQL servers. I added all my pop3 account > infiormation. When i am sending an email using xp_sendmail, xp_send amil > was > successfull, I am not getting messages. Then i stopped the mail services > and > I opened outlook all these messages are in the out look there are not > trasfered to to my email. any idia , what 's going on, how can i resolve > this > issue. > -- > SQL serer DBA
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
