Configuring Database Mail with Powershell and SMO

Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.

Send email in a tabular format using SQL Server database mail

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.

Implementing SQL Server Database Mail

Have you ever wished your database could tell you what's wrong or let you know when a task has completed? SQL Server's Database Mail allows the database to send out messages over SMTP. Deanna Dicken shows you how to set up Database Mail and send some messages.

Sending HTML Newsletters in a Batch Using SQL Server

Sending a large volume of emails can put a strain on a mail relay server. However many people using SQL Server will need to do just that for things like newsletters, mailing lists, etc. Satnam Singh brings us a way to spread out the load by sending newsletters in multiple batches instead of one large process.

How to use Database mail feature in SQL Server 2000

This article describes a way by which we could use the feature of database mail in SQL Server 2000 itself which is a lot easier than SQL Mail.

Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail

Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.

database mail

Database Mail, Part 2 - SQL School Video

Database Mail is an essential part of administering SQL Server for most people. MVP Andy Warren brings us part 2 of how to set up this subsystem.

Updating Datbase Mail Exchange Server

Problem: We are replaceing our exchange server with a new one all DBMAILs on all server use the old one

Sending E-mail from SQL Server 200X

From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.