UFN_GLOBALDUPLICATESEARCH_ISENABLED

Returns whether global duplicate search is enabled.

Return

Return Type
bit

Definition

Copy


            CREATE function dbo.UFN_GLOBALDUPLICATESEARCH_ISENABLED()
            returns bit
            as
            begin
                declare @DUPLICATESEARCHENABLED bit
                select top 1 @DUPLICATESEARCHENABLED = DUPLICATESEARCHENABLED from dbo.GLOBALDUPLICATESEARCHSETTINGS order by DATEADDED

                if @DUPLICATESEARCHENABLED is null
                    set @DUPLICATESEARCHENABLED = 0

                return @DUPLICATESEARCHENABLED
            end