USP_SECUREGATEWAY_CREDENTIALS_GETBYNAME

        create procedure dbo.USP_SECUREGATEWAY_CREDENTIALS_GETBYNAME(
            @NAME nvarchar(500)
        )
        as
        begin
            -- Get the credential for the given name

            -- Credential name is unique

            set nocount on;

            exec dbo.USP_GET_KEY_ACCESS;
            begin try  
                select 
                    [ID],
                    [NAME],
                    cast(DecryptByKey(ACCESSKEY) as nvarchar(200)) AS [ACCESSKEY],
                    [ENTITLEMENTTYPE],
                    [ADDEDBYID],
                    [CHANGEDBYID],
                    [DATEADDED],
                    [DATECHANGED]
                from
                    dbo.[SECUREGATEWAYCREDENTIALS]
                where
                    [NAME]=ltrim(rtrim(@NAME));

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

            return 0;
        end