Post reply

XP_MAIL and multiple mail boxes

  • August 7, 2007 at 8:36 am

    #69668

    I am not very knowledgeable in this area, but from what  I understand a SQL server can only use XP_send mail from one mail client?

     

    So if I set up an inbox ‘myserversmail’ all xp_mail would go through this? IS there any way I could have 2 or more SQL mail boxes. This would be especially useful when using xp_findnextmsg etc if I could specify which mail box to look in. Instead of being forced to use the one and only default. I really hope I have misunderstood and that I can have multiple mail boxes.

     

    Many thanks

     

  • August 7, 2007 at 9:33 am

    #725202

    SQL 2000 - One mailbox. The reason is the service account logs into Outlook and Exchange/SMTP servers, using that particular account. You can do it personally with Outlook, but you have to physically switch to a new account by clicking on "New" from that account's folders.

    If you want to handle mutliple messages, you're better off using the Subject line to route them. Actually xp_findnextmsg can be a huge security hole if the server is reading mail. Especially if you run queries off data in the mail as parameters.

    The best thing is to try and get your "messages" into a table somehow, even with a dedicated mail reader (automated, of course). Then have jobs "check" the table for new messages. Could make things easier and it's a touch more scalable. Ideally you'd move to SS2K5 and Service Broker for messages moving between systems.

    Steve

  • August 8, 2007 at 12:50 am

    #725359

    many thanks it is as I thought,

  • August 9, 2007 at 12:46 am

    #725624

    Ed -

    Another option on a SQL 2000 box is to use a SMTP mailer - search on this site for "smtp mail" and you'll find some good alternatives to xp_sendmail - most use CDO to send mail which may or may not be a problem in your environment.

    Joe

     

  • August 9, 2007 at 7:46 am

    #725715

    xp_smtpmail, by Gert Drapers works great. He's now at MS, but many people have been happy with that.

  • August 9, 2007 at 4:43 pm

    #725870

    check out

    http://www.sqldev.net/xp/xpsmtp.htm

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply