Class DatabaseMailSchema.AllItem
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sysmail_allitems (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance
Contains one row for each message processed by Database Mail. Use this view when you want to see the status of all messages.
To see only messages with the failed status, use sysmail_faileditems (Transact-SQL). To see only unsent messages, use sysmail_unsentitems (Transact-SQL). To see only messages that were sent, use sysmail_sentitems (Transact-SQL).
See dbo.sysmail_allitems.
[Table(Database = "msdb", Schema = "dbo", Name = "sysmail_allitems", IsView = true)]
public class DatabaseMailSchema.AllItem- Inheritance
-
DatabaseMailSchema.AllItem
- Extension Methods
Properties
AppendQueryError
The append_query_error parameter of the message. 0 indicates that Database Mail should not send the e-mail message if there is an error in the query.
[Column("append_query_error")]
[NotNull]
public bool AppendQueryError { get; set; }Property Value
AttachQueryResultAsFile
When the value is 0, the query results were included in the body of the e-mail message, after the contents of the body. When the value is 1, the results were returned as an attachment.
[Column("attach_query_result_as_file")]
[NotNull]
public bool AttachQueryResultAsFile { get; set; }Property Value
AttachmentEncoding
The type of mail attachment.
[Column("attachment_encoding")]
[NotNull]
public string AttachmentEncoding { get; set; }Property Value
BlindCopyRecipients
The e-mail addresses of those who receive copies of the message but whose names do not appear in the message header.
[Column("blind_copy_recipients")]
[NotNull]
public string BlindCopyRecipients { get; set; }Property Value
Body
The body of the message.
[Column("body")]
[NotNull]
public string Body { get; set; }Property Value
BodyFormat
The body format of the message. The possible values are TEXT and HTML.
[Column("body_format")]
[NotNull]
public string BodyFormat { get; set; }Property Value
CopyRecipients
The e-mail addresses of those who receive copies of the message.
[Column("copy_recipients")]
[NotNull]
public string CopyRecipients { get; set; }Property Value
ExcludeQueryOutput
The exclude_query_output parameter of the message. For more information, see sp_send_dbmail (Transact-SQL).
[Column("exclude_query_output")]
[NotNull]
public bool ExcludeQueryOutput { get; set; }Property Value
ExecuteQueryDatabase
The database context within which the mail program executed the query.
[Column("execute_query_database")]
[NotNull]
public string ExecuteQueryDatabase { get; set; }Property Value
FileAttachments
A semicolon-delimited list of file names attached to the e-mail message.
[Column("file_attachments")]
[NotNull]
public string FileAttachments { get; set; }Property Value
Importance
The importance parameter of the message.
[Column("importance")]
[NotNull]
public string Importance { get; set; }Property Value
LastModDate
The date and time of the last modification of the row.
[Column("last_mod_date")]
[NotNull]
public DateTime LastModDate { get; set; }Property Value
LastModUser
The user who last modified the row.
[Column("last_mod_user")]
[NotNull]
public string LastModUser { get; set; }Property Value
MailItemID
Identifier of the mail item in the mail queue.
[Column("mailitem_id")]
[NotNull]
public int MailItemID { get; set; }Property Value
ProfileID
The identifier of the profile used to send the message.
[Column("profile_id")]
[NotNull]
public int ProfileID { get; set; }Property Value
Query
The query executed by the mail program.
[Column("query")]
[NotNull]
public string Query { get; set; }Property Value
QueryResultHeader
When the value is 1, query results contained column headers. When the value is 0, query results did not include column headers.
[Column("query_result_header")]
[NotNull]
public bool QueryResultHeader { get; set; }Property Value
QueryResultSeparator
The character used to separate columns in the query output.
[Column("query_result_separator")]
[NotNull]
public string QueryResultSeparator { get; set; }Property Value
QueryResultWidth
The query_result_width parameter of the message.
[Column("query_result_width")]
[NotNull]
public int QueryResultWidth { get; set; }Property Value
Recipients
The e-mail addresses of the message recipients.
[Column("recipients")]
[NotNull]
public string Recipients { get; set; }Property Value
SendRequestDate
The date and time the message was placed on the mail queue.
[Column("send_request_date")]
[NotNull]
public DateTime SendRequestDate { get; set; }Property Value
SendRequestUser
The user who submitted the message. This is the user context of the database mail procedure, not the From: field of the message.
[Column("send_request_user")]
[NotNull]
public string SendRequestUser { get; set; }Property Value
Sensitivity
The sensitivity parameter of the message.
[Column("sensitivity")]
[NotNull]
public string Sensitivity { get; set; }Property Value
SentAccountID
The identifier of the Database Mail account used to send the message.
[Column("sent_account_id")]
[NotNull]
public int SentAccountID { get; set; }Property Value
SentDate
The date and time that the message was sent.
[Column("sent_date")]
[NotNull]
public DateTime SentDate { get; set; }Property Value
SentStatus
The status of the mail. Possible values are:
sent - The mail was sent.
unsent - Database mail is still attempting to send the message.
retrying - Database Mail failed to send the message but is attempting to send it again.
failed - Database mail was unable to send the message.
[Column("sent_status")]
[NotNull]
public string SentStatus { get; set; }Property Value
Subject
The subject line of the message.
[Column("subject")]
[NotNull]
public string Subject { get; set; }