Folks,
I cannot check this out until I get back to the office but, is database mail included with the express edition?
If so it really saves my @ss.
Thanks
Mick
Very nice article on initial Database Mail configuration. I wanted to point out that there are a few more steps required to have SQL Server Agent be able to use Database Mail for jobs, alerts, etc. This is from SQL Server 2005 BOL, "Using Database Mail with SQL Server Agent":
(I struck through the steps that were covered in the article, assuming that the account and profile created are Ok to use for SQL Server Agent Mail.)
It's also important to note that SQLMail issues typically fell into a couple of major categories:
With SQLMail you could spend a lot of time installing Outlook, creating operators, assigning notifications to jobs, alerts, etc., on each and every SQL Server (Config overhead)... and even then it may or may not work (Reliability)
By taking MAPI/SQLMail out of the mix and going to SMTP with failover Microsoft has addressed biggest element of the "reliability" issue. However, there is still the fact that Database Mail is a distributed system -- if there is some problem with it on one or more SQL Servers, then you may not receive your notifications for those servers. In other words, although each individual Database Mail instance is inherently more reliable than SQLMail when properly configured and maintained, there is still no outside-looking-in process making objective decisions on the health of Database Mail on all servers, which goes towards "enterprise reliability".
In terms of maintenance overhead, I am sure many of those familiar with setup of SQLMail will look at the Database Mail setup & config process and think, "Well, it sure is different... and easier in some respects... but it's still quite a bit of work".
Database Mail still needs to be configured and tested on each SQL Server, operators need to be created, and the DBA must remember to assign notifications to all jobs & alerts, including new jobs & alerts added after initial setup. When you start multiplying this by 50, 100, 250 or more SQL Servers as is commonplace now for many organizations, a migration from 2000/SQLMail to 2005/Database Mail starts to get a bit scary.
Microsoft has certainly made a big move in the right direction with Database Mail, but there is still a ways to go before it can truly be considered an "enterprise friendly" notification solution.
Greg GonzalezsqlSentry
I would add #7 to Greg's list:
7. Issue a statement that send an email.
I use Database Mail and for some reason it works. I am using a statement like that:
EXEC dbo.sp_send_dbmail @recipients='yelena.varshal@philips.com', @subject = 'Subject of my Email, @query ='Select * from ##MyTempTable' @profile_name = 'DBAemail', @attach_query_result_as_file = 0
I would also add #1.5 if applicable:
1.5 Specify the database.
In my CTP the next screen after you click Setup on the first screen tell you to select a certain database to install Messaging Objects. I do understand that this may change in the release that I am in the process of installing now.
"In my CTP the next screen after you click Setup on the first screen tell you to select a certain database to install Messaging Objects" - I suggest you check out the RTM. One change from early CTPs is that Database Mail is now msdb only. The ability to install multiple Database Mail instances has gone in RTM, and probably before, I don't recall exactly.
Darren,
Thanks for your explanations. I am in the process of installing RTM.
