Send Mail from SQL server 2000
in [Programming SQL]
|
From: Jay on 9 Feb 2010 07:22 I can't find the link right now, but I remember clearly that there is a way to send mail via SMTP on 2000. I liked it because it didn't require much and was very thin. I thought I got it from you Tibor. "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in message news:%23IJyokVqKHA.4492(a)TK2MSFTNGP05.phx.gbl... > SQL Server 2000 doesn't have database mail. It has SQL Mail which requires > MAPI (Outlook), art from that, we need to know what you are doing to help. > That error suggests that you run some sp_configure option which doesn't > exist in 2000 - that is all we can say with the information we have so > far. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > > "Hemant" <Hemant(a)nomail.com> wrote in message > news:u4YHuLVqKHA.3832(a)TK2MSFTNGP02.phx.gbl... >> Hi, >> >> I am trying to send mail from sql server . I have done this by sql server >> 2005 but not getting success in sql server 2000. >> >> The error is : >> The configuration option 'Ole Automation Procedures' does not exist, or >> it may be an advanced option. >> >> Please help . >> Thanks, >> hemant >>
From: Tibor Karaszi on 9 Feb 2010 07:50 Yup, that would have been Gert's xp_smtp_sendmail. Thanks for brining that up, Jay. Much better option than CDO. Hemant, Check out http://www.karaszi.com/SQLServer/info_no_mapi.asp -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Jay" <spam(a)nospam.org> wrote in message news:un6BPKYqKHA.6064(a)TK2MSFTNGP02.phx.gbl... > I can't find the link right now, but I remember clearly that there is a > way to send mail via SMTP on 2000. I liked it because it didn't require > much and was very thin. I thought I got it from you Tibor. > > "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote > in message news:%23IJyokVqKHA.4492(a)TK2MSFTNGP05.phx.gbl... >> SQL Server 2000 doesn't have database mail. It has SQL Mail which >> requires MAPI (Outlook), art from that, we need to know what you are >> doing to help. That error suggests that you run some sp_configure option >> which doesn't exist in 2000 - that is all we can say with the information >> we have so far. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> >> "Hemant" <Hemant(a)nomail.com> wrote in message >> news:u4YHuLVqKHA.3832(a)TK2MSFTNGP02.phx.gbl... >>> Hi, >>> >>> I am trying to send mail from sql server . I have done this by sql >>> server 2005 but not getting success in sql server 2000. >>> >>> The error is : >>> The configuration option 'Ole Automation Procedures' does not exist, or >>> it may be an advanced option. >>> >>> Please help . >>> Thanks, >>> hemant >>> > >
From: Dooza on 9 Feb 2010 08:32 On 09/02/2010 12:50, Tibor Karaszi wrote: > Yup, that would have been Gert's xp_smtp_sendmail. Thanks for brining > that up, Jay. Much better option than CDO. > > Hemant, > Check out http://www.karaszi.com/SQLServer/info_no_mapi.asp Seems like SQLDev.Net is empty, and that is where you are supposed to get xp_smtp_sendmail from. Dooza
From: Tibor Karaszi on 9 Feb 2010 11:24 > Seems like SQLDev.Net is empty, and that is where you are supposed to get > xp_smtp_sendmail from. Sorry to hear that. I guess that leaves the other three options (make CDO work, SQL Mail and Outlook or upgrade). -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Dooza" <steveNO(a)SPAM.dooza.tv> wrote in message news:uBtQ1wYqKHA.4236(a)TK2MSFTNGP02.phx.gbl... > On 09/02/2010 12:50, Tibor Karaszi wrote: >> Yup, that would have been Gert's xp_smtp_sendmail. Thanks for brining >> that up, Jay. Much better option than CDO. >> >> Hemant, >> Check out http://www.karaszi.com/SQLServer/info_no_mapi.asp > > Seems like SQLDev.Net is empty, and that is where you are supposed to get > xp_smtp_sendmail from. > > Dooza
First
|
Prev
|
Pages: 1 2 Prev: Which columns are in what tables Next: Stored procedure, delete from multiple tables |