USP_DATABASEMAILSETTINGS_CHECK_IF_ENABLED

create procedure dbo.USP_DATABASEMAILSETTINGS_CHECK_IF_ENABLED
  @ENABLED bit output

/*
Used by the email alert task filters to hide email alert tasks
that should not be visible if the database email settings have not been 
configured. 

The task:

    My Preferences: Configure and manage my user preferences.

uses the value of @ENABLED to filter the task.

*/

as

set nocount on;

if exists(select top(1) 1 from dbo.DATABASEMAILSETTINGS where ENABLED = 1)
    set @ENABLED=1;
else
    set @ENABLED=0;

return 0;