dbo.QBM_TUDialogDatabase

1  create   trigger QBM_TUDialogDatabase on DialogDatabase  for Update not for Replication as begin  SET XACT_ABORT OFF declare @NewProductionlevel
2 int declare @ErrorMessage nvarchar(1000)  BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start
3 return start:  if not dbo.QBM_FGIUserAccessLevel() > 3 and not (update(FESimulationStarted) or update(XUserUpdated) or update(XDateUpdated) ) begin raiserror
4 ('#LDS#Access denied with AccessLevel <= 3|', 18, 1) with nowait end declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') 
5if update(ProductionLevel) begin select @NewProductionlevel = null select top 1 @NewProductionlevel = db.ProductionLevel from DialogDatabase db join deleted
6 d on db.UID_Database = d.UID_Database where db.IsMainDatabase = 1 and isnull(db.ProductionLevel, 0) <> isnull(d.ProductionLevel, 0) if @NewProductionlevel
7 > ' ' begin update DialogConfigParm set Value = case @NewProductionlevel when 0 then 5  when 1 then 7  else 0  end where FullPath = 'QBM\DBQueue\CountSlotsMax'
8 update DialogConfigParm set Value = case @NewProductionlevel when 0 then 20  when 1 then 40  else 120  end where FullPath = 'QBM\DBQueue\KeepAlive' end
9 end if UPDATE(DataOrigin) begin exec QBM_PDBQueueInsert_Single 'QBM-K-GetServerProperties', '', '', @GenProcID end if update(UID_CutOffTask) begin if 
10(select top 1 i.UID_CutOffTask from inserted i ) is null  begin exec QBM_PSessionContextSet 'INSERTEDINTODBQUEUE', '1' end else  begin if exists (select
11 top 1 1 from deleted d join DialogDatabase i on d.UID_Database = i.UID_Database where i.UID_CutOffTask in ('QBM-K-CommonWaitForCompiler', 'QBM-K-BaseMigrationReady'
12)  and (d.UID_CutOffTask is null or i.UID_CutOffTask = d.UID_CutOffTask ) ) begin  exec QBM_PSessionContextSet 'INSERTEDINTODBQUEUE', '1' end else begin
13  select top 1 @ErrorMessage = concat('#LDS#Invalid Update in column UID_CutOffTask. Old task: {0}, New task {1}.|' , isnull(d.UID_CutOffTask, '<empty>'
14), '|' , isnull(i.UID_CutOffTask, '<empty>'), '|' ) from deleted d join DialogDatabase i on d.UID_Database = i.UID_Database where i.IsMainDatabase = 1 
15if @@TRANCOUNT > 0 begin rollback end raiserror (@ErrorMessage, 18, 1) with nowait end end end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare
16 @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 
17