Yes that makes sense, better to be 100% safe.

Thanks for your help.

Dave

That's a good point. I've not changed the default profile in the GUI as

lots of SQL jobs still need to use this profile.

Do you think...

Ahhh, figured it out.

use master

exec xp_stopmail

exec xp_startmail @user = 'GrayD'

exec xp_sendmail

@recipients = 'grayd@turpin-distribution.com', @message='Hello'

I just setup a new mail profile called 'GrayD', stopped/started mail....

Hi,

Thanks for all the responses, plenty of food for thought there.

We will be ditching SQL2000 before the end of the year but this project needs to be live...

Hi,

thanks to all who responded.

I needed these records in a flat file on a VMS box which does not support unicode.

In the end I exported the view...