dbo.QBM_TUDialogUser

1  create   trigger QBM_TUDialogUser on DialogUser  for Update not for Replication as begin  declare @ProcName nvarchar(64) = object_name(@@procid
2) declare @DebugSwitch int = 0 BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return 
3start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if @Debugswitch > 0 begin print 'entry : ' + @ProcName end if update
4(UserName) begin if exists (select top 1 1 from dialogUser u join deleted d on u.UID_DialogUser = d.UID_DialogUser where isnull(u.UserName, N'') <> isnull
5(d.Username, N'') and d.Username > ' '  ) begin raiserror( '#LDS#Cannot rename property Username.|', 18, 2) with nowait end end if update(IsAdmin) begin
6  delete DialogUserInGroup from DialogUserInGroup uig join deleted d on d.UID_DialogUser = uig.UID_DialogUser join DialogUser u on d.UID_DialogUser = u.UID_DialogUser
7 and d.IsAdmin = 1 and u.IsAdmin = 0  end if update(IsServiceAccount) or update(IsAdmin) begin   declare @DBQueueElements_01 QBM_YDBQueueRaw insert into
8 @DBQueueElements_01(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from ( select distinct u.UID_DialogUser as uid from deleted d join DialogUser
9 u on d.UID_DialogUser = u.UID_DialogUser where d.IsAdmin <> u.IsAdmin or d.IsServiceAccount <> u.IsServiceAccount ) as x exec QBM_PDBQueueInsert_Bulk 
10'QBM-K-DialogUserInGroup', @DBQueueElements_01 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH if
11 @Debugswitch > 0 begin print 'exit : ' + @ProcName end end 
12