December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Related Views and Procedures
To report on the status of all your Database Mail objects without relying on wizards and properties pages, you need some tabular views and stored procedures. msdb contains many system tables, views, and corresponding stored procedures that make this task easy. The following section lists the tables (or views) and their columns, noting the stored procedure (if any) that you can use to read from them.