USP_DATAFORMTEMPLATE_EDIT_SFTPFINDERSERVICESSETTING

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SFTPFINDERSERVICESSETTING 
                    (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @USERNAME nvarchar(255),
                        @PASSWORD nvarchar(200)
                    )
                    as

                        set nocount on;

                        if @CHANGEAGENTID is null  
                            exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

                        declare @CURRENTDATE datetime = getdate();

                        exec dbo.[USP_GET_KEY_ACCESS];

                        begin try
                            if (select count(1) from dbo.[SFTPFINDERSERVICESCONFIGURATION]) = 1
                            begin
                                update
                                    dbo.[SFTPFINDERSERVICESCONFIGURATION]
                                set
                                    [USERNAME] = @USERNAME,
                                    [PASSWORD] = EncryptByKey(key_GUID('sym_BBInfinity'), @PASSWORD),
                                    [CHANGEDBYID] = @CHANGEAGENTID,
                                    [DATECHANGED] = @CURRENTDATE;
                            end
                        end try
                        begin catch
                            close symmetric key sym_BBInfinity;

                            exec dbo.[USP_RAISE_ERROR];
                            return 1;
                        end catch

                        close symmetric key sym_BBInfinity;

                        return 0;