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 |
|
OwnedByTheMan
Starting Member
35 Posts |
 Posted - 2001-03-05 : 11:48:06
|
| I was wondering if anyone could give me an assist regarding setting SQL Server 2000 send out scheduled messages.I have read all the BOL entries I could find regarding the startmail, sendmail etc procs and it seems to be fairly straightforward but I am stumped byt what should be a simple issue.First and somewhat OT. In BOL, it steps you through setting up a mail profile. If I don't have the Mail icon in Control Panel (this is where BOL directs you to setup the profile in Win2000 Server, I am using Advanced Server and I think that the method must be different.)Second, Is the SMTP Server included with WIN2000 Advanced Server MAPI compliant enough to be the mail server for sql mail?Third, Is using xp_sendmail the best choice as opposed to emailing with ASP mail objects if you are sending lists of up to 500 emails a night? It seems that the bulk properties of xp_sendmail (recipients as semi-colon delimited list). I realize that this is a very subjective question. Any info appreciated.Thanks in advance. |
|
|
|
|
|
xp_sendmail