Most likely you have an application that opens a transaction for updates, inserts, deletes, etc. and doesn't close the transaction for a long time. BCP operations can do this. Also,...
we have a situation similar to yours. if there's truly a hard file copy (or ftp) lock down, i guess you have to proceed with your sql-based solution: i don't...