MAIL CONFIG (Urgent) 
Author Message
 MAIL CONFIG (Urgent)

Hi All,

I was usinf SMTP , CDONTS to send mail from my SQL server.

I use the below SP:

CREATE  PROCEDURE AIS_SEND_MAIL




AS



begin
-- Creating the mail object.


begin
    -- Return failure flag

end

--Sending mail


begin
    -- Return failure flag

end

--Destroying the mail object


begin
    -- Return failure flag

end
end

Problem:

Currently in my client side SMTP, CDONTS are not supported. I need to use
SQL MAIL. Is it possible for me to create OLE object  for SQL MAIL.
What is the OLE Object for SQL mail?

Regards
Hari.



Sun, 15 May 2005 15:27:19 GMT
 MAIL CONFIG (Urgent)

You can just use xp_sendmail, see BOL for details.

Jacco


Quote:
> Hi All,

> I was usinf SMTP , CDONTS to send mail from my SQL server.

> I use the below SP:

> CREATE  PROCEDURE AIS_SEND_MAIL




> AS



> begin
> -- Creating the mail object.


> begin
>     -- Return failure flag

> end

> --Sending mail



> begin
>     -- Return failure flag

> end

> --Destroying the mail object


> begin
>     -- Return failure flag

> end
> end

> Problem:

> Currently in my client side SMTP, CDONTS are not supported. I need to use
> SQL MAIL. Is it possible for me to create OLE object  for SQL MAIL.
> What is the OLE Object for SQL mail?

> Regards
> Hari.



Sun, 15 May 2005 16:59:21 GMT
 MAIL CONFIG (Urgent)
or.
http://sqldev.net/xp/xpsmtp.htm


Quote:
> You can just use xp_sendmail, see BOL for details.

> Jacco



> > Hi All,

> > I was usinf SMTP , CDONTS to send mail from my SQL server.

> > I use the below SP:

> > CREATE  PROCEDURE AIS_SEND_MAIL




> > AS



> > begin
> > -- Creating the mail object.


> > begin
> >     -- Return failure flag

> > end

> > --Sending mail



> > begin
> >     -- Return failure flag

> > end

> > --Destroying the mail object


> > begin
> >     -- Return failure flag

> > end
> > end

> > Problem:

> > Currently in my client side SMTP, CDONTS are not supported. I need to
use
> > SQL MAIL. Is it possible for me to create OLE object  for SQL MAIL.
> > What is the OLE Object for SQL mail?

> > Regards
> > Hari.



Sun, 15 May 2005 21:36:07 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. MAIL CONFIG (Very urgent)

2. pgsql/config config.guess config.sub

3. Help with config.fx, config.fp, config.fpw files

4. How to config SQL Mail to use other domain user's exchange a/c

5. Guide to config Sql Mail

6. Sql agent mail Config QUESTION

7. SQL Mail Config Using Lotus Notes

8. the whole step and config of sql mail????

9. SQL Server 2000 Mail URGENT

10. Urgent - SQL Mail Problem

11. SQL MAIL WITH A SMTP SERVER - URGENT

12. SQL Mail Error, Urgent Please


 
Powered by phpBB® Forum Software