Please help.
How do you send mail from SQL Server without using SQL Mail.
Thanks.
Printable View
Please help.
How do you send mail from SQL Server without using SQL Mail.
Thanks.
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
Hey,
U can create a package and have the mailer component send a mail from the package.
Let me know if that helps!
Ketan
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.