If you’re trying to send email using Database Mail in SQL Server, but it fails to send, you can check the sysmail_event_log view to see why it failed.

The sysmail_event_log view returns one row for each Windows or SQL Server message returned by the Database Mail system. By “message”, I don’t mean the actual mail message. I mean a message such as the error message that explains why the mail failed.

You can also use the sysmail_configure_sp stored procedure to determine what types of messages are logged.

If you’re trying to send mail with SQL Server but it’s not being delivered, try checking the sysmail_faileditems view.

When sending emails from SQL Server, you can check for any unsent mail with the sysmail_unsentitems view.

If you try to send mail from SQL Server, but you get a “profile name is not valid” it’s probably because you haven’t specified a valid profile for the @profile_name argument.

In SQL Server, you can use the sysmail_delete_profileaccount_sp stored procedure to remove a Database Mail account from a profile.

You can remove the account from a specific profile, or you can remove it from all profiles. You can also remove all accounts from a given profile.

The way it works is, you provide two arguments; the account name or its ID, and the profile name or its ID. If you omit the argument for the profile, the account is removed from all profiles. If you omit the argument for the account, then all accounts are removed from the profile.

In SQL Server, you can use the sysmail_delete_profile_sp stored procedure to delete an existing Database Mail profile.

You can delete a profile by providing either its name or its ID (but you must provide either one or the other).

In SQL Server, you can use the sysmail_delete_account_sp stored procedure to delete an existing Database Mail account.

You can delete an account by providing either its name or its ID (but you must provide either one or the other).