Showing posts with label byexec. Show all posts
Showing posts with label byexec. Show all posts

Friday, 10 February 2012

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

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