Page 108 - DCAP508_DATABASE_ADMINISTRATION
P. 108
Database Administration
Notes
Figure 7.1: Database Mail Architecture
Only members of the DatabaseMailUserRole in the msdb database can execute sp_send_dbmail.
Self Assessment
Fill in the blanks:
1. Database Mail is designed on a ………………architecture that uses service broker
technologies.
2. Configuration and security objects create profiles and accounts used by ………………
3. To send Database Mail, you must be a member of the ……………… database role in the
msdb database.
4. Database Mail uses the standard ……………… to send mail.
5. Database Mail is designed for reliability, scalability, security, and ………………
7.2 Event Notifications
Event notifications are a special kind of database object and send information about server and
database events to a Service Broker service. This section provides the information that is required
to understand, design, and implement event notifications.
102 LOVELY PROFESSIONAL UNIVERSITY
