Database Mail Catalog views display metadata about the status of e-mail messages processed by Database Mail.
USE MSDB
select * from sysmail_allitems
Contains a row for each attachment submitted to Database Mail.
USE MSDB
select * from sysmail_mailattachments
Contains returned message details for Windows or SQL Server
USE MSDB
select * from sysmail_event_log
Contains a row for each message sent successfully
USE MSDB
select * from sysmail_sentitems
Contains one row for each failed message
USE MSDB
select * from sysmail_faileditems
Contains row for Messages with unsent or retrying status which are still in the mail queue
USE MSDB
select * from sysmail_unsentitems
Chaos, complexity, curiosity and database systems. A place where research meets industry
Welcome
Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
Wednesday 24 February 2010
Friday 5 February 2010
SQL Server Version Numbering
This defines the product version numbering format for SQL Server. It is MM.nn.bbbb.rr which is defined as:
MM - Major version
nn - Minor version
bbbb - Build number
rr - Build revision number
MM - Major version
nn - Minor version
bbbb - Build number
rr - Build revision number
Subscribe to:
Posts (Atom)