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 |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2003-01-20 : 12:44:16
|
| We're (finally) moving to SQL2K on our production server in a few weeks. Currently, we use SQL7 and I once had the Groupwise client working with SQL Mail but it never worked all that well (long delays, crashes).Since we are a Groupwise shop, I don't have Exchange available to use. Does anyone have experience with running a small pop/imap mail server on the SQL box? I'm looking for whether this is a good idea or not and if so, any mail application recommendations (we simply need to send mail out).Thanks |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-01-20 : 12:49:19
|
| Have a look at xp_smtp_sendmail as an alternative (just needs SMTP)[url]http://sqldev.net/xp/xpsmtp.htm[/url]HTHJasper Smith |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-21 : 05:47:22
|
| I had tried using sql mail (mapi) in sql 2k ,I had to configure ms outlook on the server and it was a hell lot of problems sending the attachments and it is slower too.better analyse the things before hand before actually going with it.REGARDS,Harshal.Expect the UnExpected |
|
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-01-21 : 06:06:16
|
| Thanks for the suggestions. I'm checking to see if our mail servers have open relay as required by the xp_smtp_sendmail procedure. If not, I may have to use a local POP3 server or get muddle through the process of working with Groupwise. |
|
|
|
|
|
|
SQL2K and mail