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

    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
    @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?



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

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


Posting Permissions

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