USP_DATAFORMTEMPLATE_VIEW_RECOGNITIONDEFAULTANONYMOUSSETTINGS

            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RECOGNITIONDEFAULTANONYMOUSSETTINGS
            (
                @DATALOADED bit = 0 output,
                @DEFAULTANONYMOUSRECOGNITION bit = null output
            )
            as
                set nocount on;

                -- be sure to set this, in case the select returns no rows
                set @DATALOADED = 0;

                select top 1
                    @DATALOADED = 1,
                    @DEFAULTANONYMOUSRECOGNITION = DEFAULTANONYMOUSRECOGNITION
                from dbo.RECOGNITIONDEFAULT

                if @DATALOADED = 0
                begin
                    set @DATALOADED = 1
                    set @DEFAULTANONYMOUSRECOGNITION = 0
                end
                return 0;