UFN_BBNC_TRIGGERSENABLED

            CREATE function dbo.UFN_BBNC_TRIGGERSENABLED ()
            returns bit
            as begin
                return (
                    select top 1 
                        case when IS_DISABLED = 0 then 1 else 0 end as ENABLED
                    from 
                        sys.triggers
                    where 
                        [NAME] like 'TR_%BBNC%IDMAP'
                    order by
                        [IS_DISABLED] desc
                    )
            end