• 

 

RECEBA O CÓDIGO DE ERRO NO SEU EMAIL  

DECLARE @Desc VARCHAR (5000) 
BEGIN TRY
    -- Generate a divide-by-zero error.
    SELECT 1/0;
END TRY

BEGIN CATCH
        SET  @Desc = 'ERROR:'+ CAST(ERROR_NUMBER() AS VARCHAR(20))+' '+
                CAST(ERROR_SEVERITY() AS VARCHAR(3))+' '+
                CAST(ERROR_STATE() AS VARCHAR(3))+' '+
                CAST(IsNull(ERROR_PROCEDURE(),'') AS VARCHAR(25))+' '+
                CAST(ERROR_LINE()AS VARCHAR(10))+' '+
                CAST(ERROR_MESSAGE() AS VARCHAR(210))
EXEC msdb.dbo.sp_send_dbmail
	@profile_name = '<< NOME_DO_PROFILE_DO_SERVIDOR_DE_BANCO >>',
	@recipients = 'EMAIL_DO_DESTINATARIO@BLABLA.COM.BR',
	@body = @Desc,
	@subject = 'ERRO MANUTENCAO SWHSQL2008' 
END CATCH;