USP_KPIINSTANCEMILESTONE_DELETEBYKPIINSTANCEID

            CREATE procedure dbo.USP_KPIINSTANCEMILESTONE_DELETEBYKPIINSTANCEID(@KPIINSTANCEID uniqueidentifier, @CHANGEAGENTID uniqueidentifier)
            as
                set nocount on;

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

                /* cache current context information */
                set @contextCache = CONTEXT_INFO();

                /* set CONTEXT_INFO to @CHANGEAGENTID */
                if not @CHANGEAGENTID is null
                    set CONTEXT_INFO @CHANGEAGENTID;

                delete from dbo.KPIINSTANCEMILESTONE where KPIINSTANCEID = @KPIINSTANCEID;

                /* reset CONTEXT_INFO to previous value */
                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


                return 0;