September 2010
Intermediate to advanced
1704 pages
111h 8m
English
The first set of msdb objects we’ll review are those related to system objects such as profiles, profile security, and accounts:
• sysmail_profile—Contains basic profile data, including the unique profile_id, name, description, last_mod_datetime, and last_mod_user name. You execute sysmail_help_profile_sp to retrieve this data by @profile_name or @profile_id.
• sysmail_principalprofile—Contains profile security settings, including the profile_id, associated principal (or user) (principal_SID), profile default status (is_default: 1 for yes or 0 for no), last_mod_datetime, and last_mod_user name. You execute sysmail_help_principalprofile_sp to retrieve this data by @profile_name, @profile_id, @principal_name ...