USP_SKYACCESSKEY

CREATE procedure dbo.USP_SKYACCESSKEY
as
begin
  set nocount on;

    declare @SKYACCESSKEY nvarchar(36) = '';

    exec dbo.USP_GET_KEY_ACCESS;

    begin try
        select top 1
            @SKYACCESSKEY = convert(nvarchar(36), DecryptByKey(SKYACCESSKEY))
        from dbo.SKYACCESS
        order by DATEADDED;

        close symmetric key sym_BBInfinity;
    end try
    begin catch
        close symmetric key sym_BBInfinity;
    exec dbo.USP_RAISE_ERROR;
    end catch

    select @SKYACCESSKEY as SKYACCESSKEY;

end