--select top 100 [name], [id], [xtype] from sysobjects

declare @тело_письма varchar(max)

set @тело_письма = ''

select @тело_письма = '<table cellpadding=3 cellspacing=0 border=1><tr style="color:White;background-color:SteelBlue;font-weight:bold;"><td>Name</td>' +
'<td>id</td><td>xtype</td><td>crdate</td></tr>' +
cast ((
select top 100 [Tag] = 1, [Parent] = 0, 
[tr!1!td!element] = [name], 
[tr!1!td!element] = [id], 
[tr!1!td!element] = [xtype],
[tr!1!td!element] = convert(varchar,[crdate],104)
from sysobjects
for xml explicit
) as varchar(max) ) 
+ '</table>'

select @тело_письма  -- Эту строку можно отправить по почте