Database Mail
E56725
Database Mail is a SQL Server component that enables the database engine to send email messages, alerts, and query results using SMTP.
Observed surface forms (1)
| Surface form | Occurrences |
|---|---|
| Database Mail Configuration Wizard | 1 |
Statements (48)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
email messaging component ⓘ |
| configuredWith |
Database Mail
self-linksurface differs
ⓘ
surface form:
Database Mail Configuration Wizard
Transact-SQL stored procedures ⓘ |
| developedBy | Microsoft ⓘ |
| hasComponent |
Database Mail account
ⓘ
Database Mail log ⓘ Database Mail profile ⓘ |
| hasStoredProcedure |
sp_send_dbmail
ⓘ
sysmail_add_account_sp ⓘ sysmail_add_profile_sp ⓘ sysmail_add_profileaccount_sp ⓘ sysmail_configure_sp ⓘ |
| hasView |
sysmail_allitems
ⓘ
sysmail_event_log ⓘ sysmail_faileditems ⓘ sysmail_sentitems ⓘ |
| introducedInVersion |
SQL Server
ⓘ
surface form:
SQL Server 2005
|
| loggingLocation |
msdb.dbo.sysmail_allitems
ⓘ
msdb.dbo.sysmail_event_log ⓘ |
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| replaces | SQL Mail ⓘ |
| requires |
SQL Server
ⓘ
surface form:
SQL Server Database Engine
configured SMTP server ⓘ |
| runsOutsideProcess |
SQL Server
ⓘ
surface form:
SQL Server Database Engine
|
| storesConfigurationIn | msdb database ⓘ |
| supportsAttachment | file attachments ⓘ |
| supportsAuthentication |
Windows authentication (via SMTP relay, environment-dependent)
ⓘ
basic SMTP authentication ⓘ |
| supportsFeature |
attachment size limits configuration
ⓘ
multiple email accounts per profile ⓘ multiple email profiles ⓘ prioritized accounts within a profile ⓘ retry logic for failed email delivery ⓘ sending alerts ⓘ sending email messages ⓘ sending query results ⓘ |
| supportsFormat |
HTML email
ⓘ
plain text email ⓘ |
| supportsSecurityFeature |
account-based security
ⓘ
profile-based security ⓘ |
| usedFor |
database monitoring alerts
ⓘ
sending job notifications ⓘ sending operator alerts ⓘ sending query result sets ⓘ |
| usesProtocol | SMTP ⓘ |
| usesService |
SQL Server Agent
ⓘ
Service Broker ⓘ |
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
Database Mail Configuration Wizard