USP_DATAFORMTEMPLATE_EDITLOAD_ENQUEUESETTINGS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ENQUEUESETTINGS
(
  @APPUSERID uniqueidentifier = null output,
  @PASSWORD nvarchar(100) = null output,
  @DATALOADED bit = 0 output
)
as

  set nocount on;

  exec dbo.USP_GET_KEY_ACCESS;

  begin try
    select
      @DATALOADED = 1,
      @APPUSERID = [ID]
    from dbo.[ENQUEUESETTINGS];

    if @DATALOADED = 0
    begin
      set @DATALOADED = 1;
      set @APPUSERID = null;
    end

    close symmetric key sym_BBInfinity;
  end try
  begin catch
    close symmetric key sym_BBInfinity;
  end catch
  return 0;