Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2002-02-07 : 00:30:53
|
| Hi, I have the following setup.Server : Window NT 4.0 SP6a.IIS 4.0SQL SERVER :7.0 SP3 installed.How can I send mails from SQL using SQL Mail.When ever some one registers in my site, I need to send a mail to that person with his user name and password.Right now I do it in ASP with CDONTS.What is the difference between these two.How should I configure the SQL mail.KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-02-07 : 02:52:45
|
| Karuna,Stick with what you are doing....send it from the front end...Why?....1) Databases aren't very good at sending email....2) Using SQLMail provides an extra amount of administration and security measures..3) If the user has been registered (ie Inserted into the DB) and the email fails... how are you going to send him another Email???If you do want to use SQLMail...Search for "email" in the Search function on this site...HTHDavidMTomorrow is the same day as Today was the day before. |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-02-07 : 03:35:24
|
| Thanks very much for informing about the differences...KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-02-08 : 01:58:55
|
| The basic idea for me to use sql mail is send newsletters, If I want to send to some 5000 people, I cant send it from my asp page,coz, the script would be timed out at half way stage....The option I have is to write a dll or an exe...I thought with Sql mail it would be an easy task even if i need to send to many people...Any suggestions????KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-08 : 08:29:26
|
| Take a look at Merkin's article:http://www.sqlteam.com/item.asp?ItemID=5908You should try to find some kind of bulk email program that can process an entire folder of email messages. It's better designed to do this kind of work vs. a COM/DLL solution. |
|
|
|
|
|
|
Configuration of SQL Mail