Microsoft® SQL Server 2008 R2 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 15.1.

Table 15.1 T-SQL Stored Procedures

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

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:

Alternatively, you can simply return ...