November 6, 2007 at 9:01 am
Hi,
Can anyone please tell me the difference between Database Mail and SQL Mail.
Thanks in Advance
R.K.Nair
November 6, 2007 at 9:58 am
Corey Bunch wrote a good article -
http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/
"The main difference between SQL Mail in SQL 2000 and Database Mail in 2005 is this: SQL Mail is a headache and Database Mail is not. After experimenting briefly with Database Mail, I see no reason why one would choose the legacy SQL Mail over the new Database Mail, unless of course for backward compatibility, legacy applications, etc.
Not only does Database Mail handle the somewhat simple task of sending emails rather well. It has some other robust features that should not go unnoticed, such as...
Multiple profiles and accounts to specify multiple SMTP servers or different email infrastructure situations
SQL Server queues messages even when the external mailing process fails
High security - users and roles have to be granted permission to send mail
Logging and auditing
HTML messages, attachment size regulations, file extension requirements, etc.
With all these considerations (plus a good number that I’m not including for purposes of brevity), provided you have (or are) a good developer, you can make some use of 2005’s new Database Mail functionality."
Tommy
Follow @sqlscribeNovember 6, 2007 at 11:08 am
Thanks Tommy that was really nice ............
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply