Prev: Which columns are in what tables
Next: Stored procedure, delete from multiple tables
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