Hi,

We decided to insert the info using

BEGIN TRANSACTION

INSERT INTO DB2.dbo.Table

SELECT *

FROM DB1.dbo.Table

WHERE CodigoCaso < @cont and CodigoCaso > @ultimo

SET @ultimo = @cont

SET @cont = @cont + 1000

COMMIT TRANSACTION

In order to avoid a huge increase in the log file.

I will post the result

Thanks