Si eso losé, pero lo que no logro hacer es esto:
Código:
declare @sql nvarchar(1024);
set @sql = 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 = '[email protected]',
@subject = 'SQL Server Report',
@message = @sql