Configuring Database Mail with Powershell and SMO
Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.
2011-08-15
5,592 reads
Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.
2011-08-15
5,592 reads
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
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.
2010-11-17
3,693 reads
2009-11-23
3,110 reads
Problem: We are replaceing our exchange server with a new one all DBMAILs on all server use the old one
2009-07-27 (first published: 2009-07-08)
498 reads
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.
2009-07-01
5,326 reads
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.
2009-05-22
4,229 reads
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
2009-01-27
1,518 reads
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.
2008-08-11
3,914 reads
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
984 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers