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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sending SMTP mail via SP WITHOUT using SQL MAIL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-20 : 07:28:52
emil writes "Hello:

Is there a way to send an smtp message in a stored procedure without using SQL Mail. We used to use XPSMTP by sqldev.net but we are not sure if it is supported on our windows 2003 server with SQL 2000 sp3. Are there any other solutions out there?

Please advise and your help is greatly appreciated.

Thanks,

Emil"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-06-20 : 07:31:33
Did you try running it on that box? Don't assume it won't work until you try it. I know xp_SMTP is not the only utility of its type out there, but it's one of the better ones.
Go to Top of Page

TimS
Posting Yak Master

198 Posts

Posted - 2005-06-20 : 13:39:21
I am using xpsmtp under Windows 2003 and SQL 2000 SP3a; been using it for about a month have not had any problems.

http://www.sqldev.net/xp/xpsmtp.htm

Tim S
Go to Top of Page
   

- Advertisement -