Database Mail

External Article

Send email in a tabular format using SQL Server database mail

  • Article

Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself contains the table data. This way the recipients would be able to look at the data in a tabular format, making it easier for readability. Hence we arrived at the question of how to send email from SQL Server with data in a tabular format.

2011-04-12

5,799 reads

Blogs

Daily Coping 6 Feb 2023

By

Today’s coping tip is to get back in contact with an old friend. This...

Rotating a Certificate Used by TDE

By

In terms of encryption, Key Rotation is the process of replacing your encryption keys...

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Read the latest Blogs

Forums

Group by issue

By pedroccamara

Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...

Ownership chaining

By Duncan Lawrence

Hi, I have four views on one database to which one sql authenticated user...

Schedule Jobs on a Clustered SQL Server

By Prasad Chava

Comments posted to this topic are about the item Schedule Jobs on a Clustered...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers