SQLServerCentral.com Articles tagged Database Mail

Configuring Database Mail with Powershell and SMO

Mon, 15 Aug 2011 06:00:00 UT

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

Tue, 12 Apr 2011 06:00:00 UT

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

Wed, 17 Nov 2010 07:00:00 UT

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

Thu, 27 May 2010 06:00:00 UT

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

Tue, 09 Mar 2010 07:00:00 UT

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

Thu, 17 Dec 2009 07:00:00 UT

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, Part 2 - SQL School Video

Tue, 14 Jul 2009 06:00:00 UT

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.

Sending E-mail from SQL Server 200X

Wed, 01 Jul 2009 06:00:00 UT

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.

Mathematical Auditing Of Email Broadcasts

Fri, 22 May 2009 06:00:00 UT

In a sequel to his previous article on referential integrity, Glen Cooper looks at some ways to analyze who is getting emails based on a database system.

Database Mail and SQL Agent Mail setup by using a script

Mon, 11 May 2009 06:00:00 UT

In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.

Setting Up Database Mail - SQL School Video

Tue, 28 Apr 2009 06:00:00 UT

Learn how to get started integrating mail with your SQL Server in this SQL School video. MVP Andy Warren shows how to set up Database Mail.

Dynamically getting mail profile for sp_send_dbmail

Tue, 27 Jan 2009 07:00:00 UT

I have found that I like to generate a script once and roll it out to multiple servers at the same time. SQL Server 2008 Management Studio makes that fairly easy by allowing one window to connect to multiple instances simultaneously

Configuring Database Mail in SQL Server 2005

Mon, 11 Aug 2008 06:00:00 UT

Learn how to set up SQL Server Database Mail in SQL Server 2005. In this tip, you'll see how to configure Profiles and Accounts for sending mail.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

What do you do with a new SQL Server?

Thu, 12 Jun 2008 06:00:00 UT

This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.