probé como me sugeriste y sigo viendo el código HTML
te cito lo que dice la ayuda del parametro @TYPE de la función xp_sendmail.
Cita:
@type = 'type'
Is the input message type based on the MAPI mail definition:
IP[M | C].Vendorname.subclass
If type is NULL, message types beginning with IPM appear in the inbox of the mail client and are found or read by xp_findnextmsg. Message types beginning with IPC do not appear in the inbox of the mail client and must be found or read by setting the type parameter. The default is NULL.
For more information about using custom message types, see the Microsoft Windows NT Resource Kit or the Microsoft Mail Technical Reference, available separately.
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',
@subject = 'SQL Server Report',
@message = @sql,
@type = 'text/html'
