Microsoft® SQL Server 2012 Unleashed

Using T-SQL to Update and Delete Mail Objects

To delete or update profiles, accounts, profile-account associations, and profile security settings (note: do so in reverse order), you use the stored procedures shown in Table 12.1.

TABLE 12.1 T-SQL Stored Procedures

For example, to delete a profile, you execute this:

Click here to view code image

exec msdb.dbo.sysmail_delete_profile_sp @profile_name='Undesireable Profile Name'

To update a profile’s security, changing it from the default to the nondefault profile, you execute the following:

Click here to view code image

exec msdb.dbo.sysmail_update_principalprofile_sp    @profile_name = 'Default ...