Posted by John Bell on 06/18/05 18:54

Hi

With ADO/ODBC occasions such as when a status of SQL_SUCCESS_WITH_INFO you
can get the messages and interogate them. The options seem to be assume
that SQLMail is running and not start it every time, or to explicity stop it
first ignoring any errors which it throws up.

You may want to look at: http://www.sqldev.net/xp/xpsmtp.htm as a different
way to send emails.

John


"Mark" <markandersen@evare.com> wrote in message
news:1118667698.073828.197640@g47g2000cwa.googlegroups.com...
> "You don't say what your client is written in!"
>
> No client. This is a SQL Stored Procedure (invoked by a sql job, but
> that is irrelevant) in which I wish to call xp_startmail and
> distinguish between "failure, already started" and "failure, won't
> start".
>
> Did you test it in ADO or are you offering general advice?
>
> Mark
>

[Back to original message]