Here's the preffered way to send mail in sql server 2k5+

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'JOB SQL',

@recipients = 'rgregoire@fordia.com;remi@remigregoire.com;sbergeron@fordia.com;dcardinal@fordia.com',

@query = 'SET NOCOUNT ON; SELECT * FROM msdb.dbo.DBA_CheckDB' ,

@subject = 'ERREUR FATALE, CORRUPTION DE LA BD master',

@attach_query_result_as_file = 1,

@body = 'Voici la query qui réaffiche les résultats de CHECKDB : SELECT * FROM msdb.dbo.DBA_CheckDB',

@importance = 'HIGH',

@query_result_separator = '|',

@file_attachments = '\\Fordiavcenter\Informatique\Navision backup\Help, my database is corrupt_ Now what - SQLServerCentral.mht' -- nvarchar(max);