SQL Mail

[olutimi]

Please help.

How do you send mail from SQL Server without using SQL Mail.


Thanks.

[MAK]

http://www.databasejournal.com/sqle...cle.php/1585201

http://forums.databasejournal.com/s...hlight=smtpsend

[skhanal]

There are two options to use SMTP email,

1. Use CDOSYS object in transact-sql
2. Use a freeware called XPSMTP
http://www.sqldev.net/xp/xpsmtp.htm

[k2kataria]

Hey,

U can create a package and have the mailer component send a mail from the package.

Let me know if that helps!
Ketan

[MAK]

tooo many process involved.

for a simple email you have to call shell - which calls dtsrun - which calls a DTS - which takes the right data from a table and send email.