USP_ENQUEUESETTINGS_GET

  create procedure dbo.USP_ENQUEUESETTINGS_GET
  (
    @APPUSERID uniqueidentifier = null output,
    @PASSWORD nvarchar(100) = null output
  )
  as
    set nocount on;

    exec dbo.USP_GET_KEY_ACCESS;

    begin try
      select top 1
        @APPUSERID = [ID],
        @PASSWORD = convert(nvarchar(100), DecryptByKey([PASSWORD]))
      from dbo.[ENQUEUESETTINGS];

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