USP_GETTASKSTATUS_BBPSLOGIN

CREATE procedure dbo.USP_GETTASKSTATUS_BBPSLOGIN
(
    @STATUS tinyint = null output, 
    @DESCRIPTION nvarchar(max) = null output
)
as begin

exec dbo.USP_GET_KEY_ACCESS

declare @USERNAME nvarchar(100)
declare @PASSWORD nvarchar(100)

begin try
    select top 1
        @USERNAME = convert(nvarchar(100), DecryptByKey(USERNAME)),
        @PASSWORD = convert(nvarchar(100), DecryptByKey(PASSWORD))
    from dbo.BBPSLOGIN
    order by DATEADDED

    set @STATUS = (case when LEN(@USERNAME) > 0 and LEN(@PASSWORD) > 0 then 2 else 0 end);
    close symmetric key sym_BBInfinity
end try
begin catch
    set @STATUS = 0;
    close symmetric key sym_BBInfinity
end catch

end