Incercati sa folositi un parametru in loc de query:

DECLARE @sqlstatement NVARCHAR(4000);

SET @sqlstatement = 'SELECT 1';

EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'Profile1',
    @recipients = 'adresa@yahoo.com',
    @body = 'body ',
    @subject = 'subject' ,
    @query = @sqlstatement;

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro