One way is to turn off transactions
If you're going to repopulate from production, just backup the production database then restore on the test server. No need to delete existing rows.
>I need to remove about two millions records from a table. This is because on a development environment, I need to start from a fresh copy of the production. However, when deleting so many rows, it takes a very long time because of the log process. How to delete all the records without having this log process to slow things down?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer