USE [AtlantisDB] GO /****** Object: StoredProcedure [dbo].[DBA_DeleteALoginLogDB] Script Date: 1/19/2022 11:04:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /* SSIS paketinden execute ettirilmektedir. Paket adi : KNETARSIVSQL_Archiver_ALoginLogDB */ /* Oncesinde silinecek kayitlarin ID leri DBA.dbo.SSIS_Archiver_ALoginLogDB INSERT edilir */
ALTER PROC [dbo].[DBA_DeleteALoginLogDB] AS
deleteMore1: DELETE TOP (1000) ii FROM AtlantisDB.dbo.ALoginLogDB ii (NOLOCK) JOIN DBA.dbo.SSIS_Archiver_ALoginLogDB saii (NOLOCK) ON ii.DummyId = saii.DummyId IF @@ROWCOUNT != 0 goto deleteMore1