dbo.ARS_TATTUADSAccount

1 create   trigger dbo.ARS_TATTUADSAccount on ADSAccount  for update not for replication as begin  declare @GenProcID varchar(38) declare @ErrorMessage
2 nvarchar(4000) declare @ErrorSeverity int declare @ErrorState int declare @ret int   if exists (select top 1 1 from inserted) goto start if exists (select
3 top 1 1 from deleted) goto start goto endLabel start: BEGIN TRY if update(UID_Person) begin    declare @RecalcParameter_01 QBM_YCursorBuffer insert into
4 @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select 'irgendwas', 'ARS-AttestationRule-PA', 'A' exec QER_PITShopHelperFill_Recalc @RecalcParameter_01
5, @GenprocID declare @RecalcParameter_02 QBM_YCursorBuffer insert into @RecalcParameter_02 (ObjectKey1, UID1, Ident1) select p.ObjectKey, 'ARS-AttestationRule-KA'
6, 'A' from (select per.XObjectKey as ObjectKey from person per join inserted i on per.UID_Person = i.UID_Person union all select per.XObjectKey as ObjectKey
7 from person per join deleted d on per.UID_Person = d.UID_Person ) p exec QER_PITShopHelperFill_Recalc @RecalcParameter_02, @GenprocID  end END TRY BEGIN
8 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 
9