Trigger Definition |
---|
create trigger TR_CONSTITUENT_TASYNC_I on dbo.CONSTITUENT after insert not for replication as begin if dbo.UFN_B2T_CONTEXTISSYNC() = 0 begin insert into dbo.TA_NEWCONSTITUENT (ID) select ID from INSERTED -- note that the above inserts could fail if row is deleted and then reinserted w/ same ID before sync is run -- since we would not know anything about whether the row is really the same or not, we need to throw an exception -- to resolve, run the sync, then retry the insert end end |