Sending Email from SQL Server

[jubin]

Hi !

Could somebody give me a precise Code example for telling the SQL Server to
send E-Mail to a specified address: Example:
subject: "You got a new Date"
body text: "User B added a date with Client X for you, please consult your
to-do list and confirm or reject this."
email address: b...@unet.ac.at

What would the "SQL" Statement (I m sending it as a Pass-Through Query from
MS-Access) exactly look like ?

Thx in advance,
Jubin Zawar

[Michael Welcome]

Dear Jubin,

You send mail from SQL Server by using the xp_sendmail exteneded
stored procedure. See the SQL Server books online for all the various
options.

The main thing that they won't tell you there is how to set up
the Email connection. There is also information on this problem in
Microsofts SQL Server WEB site. The long and short of it
is that you need to install Exchange SERVER on the SQL Server
machine. The SQL Server has trouble sending messages using Exchange
CLIENT. Then you have to set up an account on exchange server that the
SQL Server will use. Finally, you need to set up the mail connection in
Enterprise manager. Once you have done all that correctly, using the
xp_sendmail routine is fairly simple.

This example sends a message to user1 that the master database is full.
xp_sendmail 'user1', 'The master database is full.'

Regards,

Michael Welcome

--
check out www.sqltech.com

jubin <a912...@unet.univie.ac.at> wrote in article
<01bc6ecf$6aed3f30$0100007f@connecstasy>...

[Karl Nilsson]

Well, it's not the easiest thing in the world.

xp_sendmail is probably what you're doing.

questions i would ask right off:
1) SQL Server ITSELF ITSELF ITSELF has NT logon rights
2) same as above
3) same as above

I would bet a penny to a dollar that PROGRAM MANAGER -> SQL SERVER -> SETUP
-> ... is not set up right....

Karl Nilsson

// eof