TR_CLASSMEETING_EDUCATIONMEETING_DELETE (Trigger)

                
                    create trigger dbo.TR_CLASSMEETING_EDUCATIONMEETING_DELETE
                        on dbo.CLASSMEETING
                        after delete
                    as
                    begin
                        set nocount on
                        
                        declare @ChangeAgentID uniqueidentifier
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENTFROMCONTEXT @ChangeAgentID output

                        --Cache current context information 

                        declare @CONTEXTCACHE varbinary(128)
                        set @CONTEXTCACHE = CONTEXT_INFO()

                        --Set CONTEXT_INFO to @CHANGEAGENTID 

                        if @CHANGEAGENTID is not null 
                          set CONTEXT_INFO @CHANGEAGENTID

                        delete from dbo.EDUCATIONMEETING
                        from dbo.EDUCATIONMEETING
                            inner join deleted on EDUCATIONMEETING.ID = deleted.EDUCATIONMEETINGID
                            left join dbo.CLASSMEETING on EDUCATIONMEETING.ID = CLASSMEETING.EDUCATIONMEETINGID
                        where CLASSMEETING.ID is null

                        --Reset CONTEXT_INFO to previous value 

                        if not @CONTEXTCACHE is null 
                          set CONTEXT_INFO @CONTEXTCACHE
                    end