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 |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2007-10-10 : 07:23:55
|
| Hi!Actually i don't where to put my topic))I ought to organize automatic delivery for customers using their emails in db. As far as i understood there are a few capabiltites for this. Sql server is installed in domen where there is also exchange server. Could anybody to show me steps to do my task?and also i'd like to test my prework if it possible on my local computeer. i have SqlServer and personal mailing address of domen.thanks in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-10 : 11:35:05
|
| Best to put thye email request into a table then have a separate task to do the send - then you can change the email solution without affecting anything else.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-10 : 13:37:27
|
| And tune how often you get an Email. You won't want an email for every row if something nuts happens and you get 10,000 email-events a minute!! |
|
|
|
|
|
|
How better to send email?