Difference between Database Mail and SQLMail ?

 Posted by Rajkatie on 6/23/2012 | Category: Sql Server Interview questions | Views: 4548 | Points: 40
Answer:

Database mail :
Based on SMTP (Simple Mail Transfer Protocol).
Introduced in Sql 2005.
No need to install Outlook.
Depend on Service Broker service.
More secure than Sqlmail.


SQLMail :
Based on MAPI (Messaging Application Programming Interface).
Used prior versions of Sql server 2005.
Require Outlook to be installed.
Leass secure than Database mail.


Source: MSDN | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response