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

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Have a total by Entity instead of Line total

By Bruin

How could I turn this into a total by Entity rather that just having...

latency sql server

By samirca007

Hello everyone I have big problem of slowness on a SQL instance in azure...

Load 2 files to SQL on 1 connection

By Bruin

I have 2 files I'm importing and have 2 different SQL tables from the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers