USP_ENCRYPTEDFILE_DELETE

            create procedure dbo.USP_ENCRYPTEDFILE_DELETE
            (
                @FILEPATH nvarchar(260),
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
                set nocount on

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

                begin try
                    declare @contextCache varbinary(128)

                    --cache current context information

                    set @contextCache = CONTEXT_INFO()

                    --set CONTEXT_INFO to @CHANGEAGENTID

                    set CONTEXT_INFO @CHANGEAGENTID

                    set @FILEPATH = rtrim(ltrim(lower(@FILEPATH)))
                    delete from dbo.ENCRYPTEDFILE where FILEPATH = @FILEPATH

                    --reset CONTEXT_INFO to previous value

                    if not @contextCache is null
                        set CONTEXT_INFO @contextCache
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0