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