-
SQL Mail
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
-
Use a package
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|