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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-01 : 23:15:33
|
| Nilesh Singh writes "I am Using xp_sendmail to send mails from Sql server to my clients.I created a cursor which fetches email id from databaseand mails the client.But i am facing prob it takes only the first row email idand sends but ignores the rest clients and some time it donot send any mail even the job runs successfullywhat can be the problem pl help me outthanxNilesh" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-01 : 23:51:28
|
| HiI would suggest setting up some sort of mail queueing system like this :http://www.sqlteam.com/item.asp?ItemID=5908SQL Mail is good for sending alerts to DBAs and the like, but for large scale client mailings it leaves a lot to be desired IMO.Damian |
 |
|
|
|
|
|
Mailing Prob.