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

A New Word: the Wends

By

the wends– n. the frustration that you’re not enjoying an experience as much as...

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Manually Updating Redgate Monitor/SQL Monitor Patch Info

By

This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using...

Read the latest Blogs

Forums

Express In-Memory OLTP

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Express In-Memory OLTP

Disaster Recovery and High Availability Solutions in SQL Server

By Smit Dagli

Comments posted to this topic are about the item Disaster Recovery and High Availability...

Designing Persistence Storage for a new Project in Azure

By BOR15K

Can someone share from their experience on various design options pros / cons, please?...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers