Database Mail

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

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

By

To be honest you probably think that migrating to the cloud sounds great, and...

DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.

By

Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I...

Introducing Data Céilí Dublin 2020 – Ireland’s newest Data Platform event

By

Today we have launched Data Céilí Dublin 2020, Ireland’s free, community led, Microsoft Data...

Read the latest Blogs

Forums

Delete Please

By kewlrobd

Delete Please

Backing up a database named update

By kewlrobd

I have what I think is a unique situation.  I recently deployed an application...

Index Usage

By juniorDBA13

Hi, I have some indexes on a table that have high user seeks and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers