>One way is to turn off transactions

Thanks

>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.

Yes, unfortunately, I am not the one who handle those procedures.