USP_FAFDATACACHE_CLEAR

create procedure dbo.USP_FAFDATACACHE_CLEAR
(
  @EVENTID uniqueidentifier
)
as
begin
    set nocount on;

    begin try
        declare @CACHEKEY nvarchar(255)
        set @CACHEKEY= 'FAF_' + CONVERT(nvarchar(36), @EVENTID)
        exec dbo.spDelete_CacheItem @Key=@CACHEKEY, @Exact=0      
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch
    return 0;
end