USP_ENCRYPTEDFILE_UPDATEPATH

Updates the path of an encrypted file.

Parameters

Parameter	Parameter Type	Mode
@OLDFILEPATH	nvarchar(260)	IN
@NEWFILEPATH	nvarchar(260)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_ENCRYPTEDFILE_UPDATEPATH
            (
                @OLDFILEPATH nvarchar(260),
                @NEWFILEPATH nvarchar(260),
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
                set nocount on

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                set @OLDFILEPATH = rtrim(ltrim(lower(@OLDFILEPATH)))
                set @NEWFILEPATH = rtrim(ltrim(lower(@NEWFILEPATH)))

                begin try
                    update dbo.ENCRYPTEDFILE set
                        FILEPATH = @NEWFILEPATH,
                        DATECHANGED = @CURRENTDATE,
                        CHANGEDBYID = @CHANGEAGENTID
                    where FILEPATH = @OLDFILEPATH
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0