You could also try using the TABLOCK hint on the inserts and if the source tables are not being updated at the time, the NOLOCK hint could reduce the number...

We are running SQL 2K on a dual processor box, dumping up about 36 gig to a partition on the local server box. This partition is used for dumps only....

I have developed several ACCESS applications with SQL Server backends. I have to retrieve data from different databases, but want to limit the number of ODBC datasources that must be...