dbo.QBM_PDBQueueCurrentResetNGen

1            create   procedure QBM_PDBQueueCurrentResetNGen(@SlotNumber int , @ErrorMessage nvarchar(max) , @ProcIDCaller int  , @maxGeneration 
2int = 10 ) as begin declare @Generation int declare @JournalMessage nvarchar(max) declare @SQLCmd nvarchar(max) declare @DebugLevel char(1) = 'W' declare
3 @UID_Task varchar(38) declare @SlotNumberSource int declare @SlotNumberTarget int declare @DBQueueToMove QBM_YDBQCSCurrentToMove declare @RowsMoved int
4  select top 1 @Generation = cu.Generation , @UID_Task = cu.UID_Task from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber select
5 @JournalMessage = concat('#LDS#Temporary lock for task {0}, {1} retries left.|' , @UID_Task, '|' , str(@maxGeneration - @Generation) , '|' ) if @Generation
6 < @maxGeneration begin select @SlotNumberSource = @SlotNumber select @SlotnumberTarget = dbo.QBM_FGIDBQueueSlotResetType('Error06') delete @DBQueueToMove
7  insert into @DBQueueToMove(UID_DialogDBQueue) select cul.UID_DialogDBQueue from QBMDBQueueCurrent cul with (readpast) where cul.SlotNumber = @SlotNumber
8 exec @RowsMoved = QBM_PDBQCS_CurrentMoveSlot @DBQueueToMove, @SlotNumberSource, @SlotnumberTarget            if not exists (select top 1 1 from DialogDatabase
9 where IsMainDatabase = 1 and UpdatePhase <> 0) and not exists (select top 1 1 from sys.tables t with (readpast) join sys.columns c with (readpast) on 
10t.object_id = c.object_id where t.name = 'DialogDatabase' and c.name = 'InitialMigrationRunning' ) and @ProcIDCaller > 0 begin exec QBM_PJournal @JournalMessage
11, @ProcIDCaller, 'W', @DebugLevel end else begin  exec QBM_PJournal @JournalMessage, @@procid, 'I', 'I' end end else begin   raiserror(@ErrorMessage, 18
12, 1) with nowait end end 
13