Sending mail through SQL Server

[RFH Reseller: creativeworks]

I'm attempting to send mail through a stored procedure within MS SQL 2000.

All the emails are within a table, and I need to scan through each record and send them a mail - I've found an easy solution (http://support.microsoft.com/kb/312839) to send mail without the need of SQL Mail, but wondered about the complexity
of looping through a table with a sproc?

I don't know if this is the best solution, but we are having trouble sending a daily email to subscribers using aspx pages and scheduled events on a dedicated server.

I hoped a stored procedure could be fired to send out emails (could be anything upto 10,000 emails).

[RFH Reseller: askjim]

Hi,

Your best bet is to either write a windows service or scheduled task to send the emails. If you would like someone to write a service or scheduled task let me know.

James

[RFH Reseller: creativeworks]

Thanks for the offer of help, but we got ourselves there in the end...!!

Regarding sending out emails with a large number of subscribers... potentially, the number of subscribers could exceed the tens of thousands - over time.

And if this is a daily email, we could see ourselves creating more emails before our server has sent all the emails from the night before!

Are there any recommendations for companies that host just SMTP servers that can quickly pump out an increasing number of emails?

[RFH Reseller: nick]

The most obvious one that springs to my mind is constant contact.

[RFH Reseller: askjim]

I am sure REDfox could provide you a dedicated server, bandwidth and SMTP server. If they are not happy to do this and only if Warren is happy I can put you in touch with the sales dept of the company I work for who can meet your requirements as we have some customers sending very large volumes of email marketing.

James