dbo.QBM_TUQBMUniqueGroup

1 create   trigger QBM_TUQBMUniqueGroup on QBMUniqueGroup  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted
2) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext
3('') if update(IgnoreEmptyValues) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select
4 x.uid, null, @GenProcID from (select distinct dbo.QBM_FGITableName(i.UID_DialogTable) as UID from deleted d join QBMUniqueGroup i on i.UID_QBMUniqueGroup
5 = d.UID_QBMUniqueGroup where d.IgnoreEmptyValues <> i.IgnoreEmptyValues ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-IndexCreateGenerated', @DBQueueElements_01
6   declare @TableName varchar(30) while exists (select top 1 1 from @DBQueueElements_01 ) begin select @TableName = null select top 1 @TableName = e.Object
7 from @DBQueueElements_01 e if @TableName is null begin continue end exec QBM_PIndexDrop @TableName, 'GEN[_]XA%' delete @DBQueueElements_01 where Object
8 = @TableName end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
9