Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: Configure SQL Server Email

    Hello, everyone:

    I want to create a stored procedure to execute validation and send results to clients. When I did testing to send email by:

    EXEC master..xp_sendmail
    @recipients='you@you.com',
    @message = 'Validation Finished',
    @subject = 'foo was fired.'

    I got error loke:

    Server: Msg 18030, Level 16, State 1, Line 0
    xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.

    How to configure Outlook and SQL Server Email next?

    Thanks

    ZYT

  2. #2
    Join Date
    Sep 2005
    Posts
    161
    I have better luck with the following:

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

    It doesn't require mapi, and doesn't Outlook to be installed or configured on the server. Just install and use.

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •