dbo.CPL_TDComplianceRule

1create   trigger CPL_TDComplianceRule on ComplianceRule  for Delete not for Replication as begin  if exists (select top 1 1 from deleted) goto start
2 return start: BEGIN TRY declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  declare @errno int declare @errmsg nvarchar(255
3) declare @UID_NonCompliance varchar(38) declare @whereclause nvarchar(1024)  if exists (select top 1 1 from deleted r where r.IsInactive = 0 and r.IsWorkingCopy
4 = 0 ) begin  raiserror( '#LDS#Enabled compliance rules cannot be deleted.|', 18, 3) with nowait end if exists (select top 1 1 from deleted r join personInBaseTree
5 pio on r.UID_NonCompliance = pio.uid_org and pio.XOrigin > 0  and r.IsWorkingCopy = 0 and r.IsInactive = 0 ) begin  raiserror( '#LDS#Compliance rules cannot be deleted after disabling until there are no more violations.|'
6, 18, 3) with nowait end  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null
7, @GenProcID from ( select d.uid_ComplianceRule as uid from deleted d ) as x exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceCheckMakeProc', @DBQueueElements_01
8 update PersonInBaseTree set XOrigin = 0 where uid_org in (select d.UID_NonCompliance from deleted d where d.IsWorkingCopy = 0 ) delete PersonInBaseTree
9 where uid_org in (select d.UID_NonCompliance from deleted d where d.IsWorkingCopy = 0 ) delete BaseTree from BaseTree b join deleted d on b.UID_Org = 
10d.UID_NonCompliance left outer join ComplianceRule r on d.UID_NonCompliance = r.UID_NonCompliance  and r.UID_ComplianceRule <> d.UID_ComplianceRule where
11 r.UID_NonCompliance is null    END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
12