UFN_ISEMAILPROCESSENABLED

CREATE function dbo.UFN_ISEMAILPROCESSENABLED(@PROCESSID uniqueidentifier)
returns bit
with execute as caller
as begin

    if (select count(*) from globalchange where GLOBALCHANGECATALOGID = @PROCESSID) <> 1
        return 0

    if (select count(*) from dbo.GLOBALCHANGE GC
                    inner join dbo.BUSINESSPROCESSSCHEDULE BPS on GC.ID = BPS.BUSINESSPROCESSPARAMETERSETID
                    inner join dbo.SCHEDULE S on S.ID = BPS.SCHEDULEID
                    where GC.GLOBALCHANGECATALOGID = @PROCESSID) <> 1
        return 0

    return (select ENABLED from dbo.SCHEDULE S
                inner join dbo.BUSINESSPROCESSSCHEDULE BPS on BPS.SCHEDULEID = S.ID
                inner join dbo.GLOBALCHANGE GC on BPS.BUSINESSPROCESSPARAMETERSETID = GC.ID
                where GC.GLOBALCHANGECATALOGID in (@PROCESSID))

end