Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Database Mail Rss

   Items 1 to 20 of 23    Older >>
 

Enable and configure DB mail using T-SQL

Use this to enable and setup database mail in sql server 2005/2008  Read more...
By Patrick Akhamie 2014/06/24 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 1,220 reads

SP Send Query Result as HTML table using DBMail

Create a stored procedure that will send the result of a query as an html table from the database mail.  Read more...
By Dave Gugg 2014/02/25 | Source: SQLServerCentral.com | Category: db_mail
Rating: |  Discuss |   Briefcase | 1,762 reads

Changing database mail account SMTP servers

This will generate a script that drops and recreates existing db mail accounts and change the smpt server.  Read more...
By Dennis Post 2013/07/08 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 592 reads

Have you configured Database Mail to utilize multiple SMTP Accounts ?

Lets start discussing about this subject by closely looking at the term Redundancy.  What is redundancy all about ? Wikipedia defines redundancy as “In engineering, redundancy is the...  Read more...
By AnupWarrier 2013/06/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,197 reads

Enable Database Mail in 2012

By Mike Hays 2012/11/07 | Category: database mail
Rating: (not yet rated) |  Discuss |   Briefcase | 1,956 reads

MSDB Tables/Views

By John Hanrahan 2012/03/06 | Category: database mail
Rating: (not yet rated) |  Discuss |   Briefcase | 2,245 reads

Configuring Database Mail with Powershell and SMO

Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.  Read more...
By Bruce Kastner 2011/08/15 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 2,729 reads

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.  Read more...
By Additional Articles 2011/04/12 | Source: MSSQLTips.com | Category: database mail
Rating:  Rate this |   Briefcase | 4,893 reads

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.   Read more...
By Additional Articles 2010/11/17 | Source: Database Journal | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 3,315 reads

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.  Read more...
By Satnam Singh 2010/05/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,946 reads

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.  Read more...
By Mohammed Moinudheen 2010/03/09 | Source: SQLServerCentral.com | Category: sql server 2000
Rating: |  Discuss |   Briefcase | 6,737 reads

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.  Read more...
By Jonathan Kehayias 2009/12/17 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,801 reads

database mail

By VM-723206 2009/11/23 | Category: database mail
Rating: (not yet rated) |  Discuss |   Briefcase | 3,075 reads

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   Read more...
By Mark Huber 2009/07/27 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 465 reads

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.  Read more...
By Andy Warren 2009/07/14 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 5,774 reads

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.   Read more...
By Additional Articles 2009/07/01 | Source: DevX | Category: database mail
Rating:  Rate this |   Briefcase | 4,327 reads

Mathematical Auditing Of Email Broadcasts

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.  Read more...
By R Glen Cooper 2009/05/22 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 4,144 reads

Database Mail and SQL Agent Mail setup by using a script

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.  Read more...
By Additional Articles 2009/05/11 | Source: MSSQLTips.com | Category: sql agent
Rating:  Rate this |   Briefcase | 3,587 reads

Setting Up Database Mail - SQL School Video

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.  Read more...
By Andy Warren 2009/04/28 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,959 reads

Dynamically getting mail profile for sp_send_dbmail

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  Read more...
By David Benoit 2009/01/27 | Source: SQLServerCentral.com | Category: database mail
Rating:  Rate this |   Briefcase | 1,373 reads
   Items 1 to 20 of 23    Older >>
 
Tags
sql server 2005 (2)    
sql server 2008 (2)    
sqlmail (2)    
video (2)    
administration (1)    
alerts (1)    
analysis services (ssas) (1)    
backup / restore (1)    
blogs (1)    
db_mail (1)    
dbmail (1)    
exchange (1)    
html (1)    
maintenance (1)    
powershell (1)    
security (1)    
smo (1)    
smtp (1)    
sql agent (1)    
sql server 2000 (1)    
sql server 7 (1)    
sql server express (1)    
stored procedure (1)    
t-sql (1)    
xp_sendmail (1)