xp_smtp_sendmail & Exchange Server

mildlimit@gmail.com

I'm trying to use xp_smtp_sendmail for sending email from SQL Server
2000. But unfortunatly it doesn't work fine 8( I tested
xp_smtp_sendmail in Query Analyzer, wrote code like

master.dbo.xp_smtp_sendmail
@FROM = N'user',
@TO = N'user@company',
@priority = N'NORMAL',
@subject = N'Hello SQL Server SMTP Mail',
@message = N'Goodbye MAPI and Outlook',
@type = N'text/plain',
@server = N'mail2000'

The xp_smtp_sendmail returned 0, but I didn't receive the letter. What
does it mean? How to configure my Exchange server step by step and
test it?

John Bell

Hi

Have you checked to see if the exchange server is configured to receive smtp
mail from your machine?

Use a fully qualified name for the server or an IP address. Make sure that
it is receiving SMTP on port 25, if not specify a port number. You can test
the connection to the server using the ping parameter e.g

declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail @server = N'mail2000.sqldev.net',
@ping = 1
select @rc

John

"" wrote:

> I'm trying to use xp_smtp_sendmail for sending email from SQL Server
> 2000. But unfortunatly it doesn't work fine 8( I tested
> xp_smtp_sendmail in Query Analyzer, wrote code like
>
> master.dbo.xp_smtp_sendmail
> @FROM = N'user',
> @TO = N'user@company',
> @priority = N'NORMAL',
> @subject = N'Hello SQL Server SMTP Mail',
> @message = N'Goodbye MAPI and Outlook',
> @type = N'text/plain',
> @server = N'mail2000'
>
> The xp_smtp_sendmail returned 0, but I didn't receive the letter. What
> does it mean? How to configure my Exchange server step by step and
> test it?
>