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
ZYTI 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
Showing posts with label validation. Show all posts
Showing posts with label validation. Show all posts
Subscribe to:
Posts (Atom)