Snippet Name: envsend
Tags: helpful,scriptgeneration
Created Date: Jan 31 2022 12:30PM
Last Modified Date: Apr 1 2022 11:23AM
–desc: Script an example for each databasemail profile
Dependencies: none-standalone code
default description
Sample Output:
--desc: Script an example for each databasemail profile
SELECT name,
'
declare @htmlbody varchar(4000)
set @htmlbody = ''<html><head>
<title> Embedded Logo Example</title>
<meta name="Generator" content="EditPlus">
<meta name="Author" content="">
<meta name="Keywords" content="">
<meta name="Description" content="">
</head>
<body>
<table><tr><td valign="top" align="left">MyHeader</td></tr>
<tr><td valign="top" align="left"><img src="cid:sqlservercentral_logo.gif" width="235" height="70" border="0" alt=""></td></tr>
</table>
</body></html>''
EXEC msdb.dbo.sp_send_dbmail
@profile_name=''' + name + ''',
@recipients=''lowell@stormrage.com'',
@subject = ''SQL 2008 email test'',
@body = @htmlbody,
@body_format = ''HTML'',
@query = ''SELECT top 3 * from sysobjects where xtype=''''U'''''',
@query_result_header = 0,
@exclude_query_output = 1,
@append_query_error = 1,
@attach_query_result_as_file = 1,
@query_attachment_filename = ''results.txt'',
@query_result_no_padding = 1,
@file_attachments = ''C:\sqlservercentral_logo.gif''
' AS MailExample
FROM msdb.dbo.[sysmail_profile]