USP_EVENTONSALEINFORMATION_DELETE

        create procedure dbo.USP_EVENTONSALEINFORMATION_DELETE
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier
        )
        as
        begin

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

            declare @e int;
            declare @contextCache varbinary(128);

            set @contextCache = CONTEXT_INFO();

            if not @CHANGEAGENTID is null
                set CONTEXT_INFO @CHANGEAGENTID

            delete from dbo.EVENTSALESMETHOD
            where EVENTID = @ID

            if not @contextCache is null
                set CONTEXT_INFO @contextCache

            select @e=@@error;

            if @e<>0 return -456; --always return non-zero sp result if an error occurs

        end