Trigger Definition
|
|---|
CREATE trigger TR_PROSPECTRESEARCHREQUESTCONSTITUENTNOTE_T2BDELETE on dbo.PROSPECTRESEARCHREQUESTCONSTITUENTNOTE after delete not for replication as begin -- TAIntegration data sync if dbo.UFN_B2T_CONTEXTISSYNC() = 1 update dbo.B2TROWS set SYNCSTATUSCODE = 11 where BBECID in(select ID from DELETED) and BBECTABLE = 'PROSPECTRESEARCHREQUESTCONSTITUENTNOTE' end |
