Steve:

Are you referring to the memory leak problem of using COM Objects in SQL?

I do make use of them quite a bit but I always destroy the object at the...

Here is a proc that does it. You have to supply some of the variables, so look closely at the properties.

-- ------------------------------------

Drop Proc Send_JMail

go

Create Proc Send_JMail @EMail varchar(100),

@Sub varchar(100),

I switched to using JMail Object in the proc and it works fine.

JMail is available free for private use.

That doesn't work in Exchange client.

I'm now experimenting with CDONTS Object

in Sql Server. It doesn't have the same ability as xp_sendmail, but it may do.

quote:

---

Have not tried it - a quick hack would be to wrap your message in HTML tags, most email clients will switch...