coloco lo que me enviaste en la cabezera del MIME, pero igual sigue sin funcionar
Código:
set @sql = N'MIME-Version: 1.0' +CHaR(13)+ CHaR(10)+'Content-type: text/html' +CHaR(13)+CHaR(10)
-- +N+CHaR(13)+ CHaR(10)
+N'Content-type: text/html'+ char(13)
+N'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">'+ char(13)
+N'<html>'+ char(13)
+N'<head>'+ char(13)
+N'</head>'+ char(13)
+N'<body>'+ char(13)
+N'<p><b>TEST</b></p>'+ char(13)
+N'</body>'+ char(13)
+N'</html>'
use master
exec xp_startmail
EXEC xp_sendmail @recipients = 'xxx@xxx',
@subject = 'SQL Server Report',
@message = @sql