USP_EVENTCOORDINATOR_DELETE

Executes the "Event Coordinator: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                    CREATE procedure dbo.USP_EVENTCOORDINATOR_DELETE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as begin
                        --check deletion rules, if any

                        declare @ISPRIMARY bit;
                        declare @EVENTID uniqueidentifier;
                        select @ISPRIMARY = ISPRIMARY, @EVENTID = EVENTCOORDINATOR.EVENTID from dbo.EVENTCOORDINATOR where ID = @ID

                        if @ISPRIMARY = 1 and (select count(EVENTCOORDINATOR.ID) from dbo.EVENTCOORDINATOR where EVENTCOORDINATOR.EVENTID = @EVENTID) > 1
                          raiserror('ERR_EVENTCOORDINATOR_CANNOTDELETE_HASPRIMARY', 16, 1);

                        begin try
                            exec USP_EVENTCOORDINATOR_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                        return 0;
                    end