create trigger TR_MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS_DELETE on dbo.MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS with execute as owner after delete not for replication as set nocount on;
delete from dbo.BUSINESSPROCESSSTATUS where ID in (select ID from DELETED)
