Hi Koen,

thanks for the fast answer. But is there no other chance to load the table at the same time? Because i thought that because of the partioned tables that no locks appear on the entire table but only on the relevant partition. The lock escalation of the table is also set to "AUTO".

So you say that it isn't possible with sql server to load data into differnt partitions of one table at the same time without locks? So can you explain me what is the reason therfore?