TR_STUDENTCOURSEREQUEST_DELETE

CREATE trigger [dbo].[TR_STUDENTCOURSEREQUEST_DELETE] ON [dbo].[STUDENTCOURSEREQUEST] AFTER DELETE
AS 

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 
    dbo.STUDENTCOURSE 
from 
    dbo.STUDENTCOURSE
inner join deleted D
    on STUDENTCOURSE.ID = D.ID
where not exists 
    (select ID 
    from dbo.STUDENTCLASSMEETINGGROUP 
    where STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID = D.ID)

--Reset CONTEXT_INFO to previous value 

if not @CONTEXTCACHE is null 
  set CONTEXT_INFO @CONTEXTCACHE