Please provide details of any error messages and some details on what you are trying to do.

Hi there,

A good idea would be to post us the query to are trying to run.

You may want to omit sensitive data (if applicable).

Cheers,

This always works for me.

-- this configures the database mail on the server

exec sp_configure 'show advanced options', 1

reconfigure

exec sp_configure 'Database Mail XPs', 1

reconfigure

-- this sends mail

DECLARE @p_body as nvarchar(max), @p_subject...