I have an application that creates files to be processed by SQL bulk. The files are created in shared folder on another server and than taken from there by SQL.
The problem that sometime SQL returns an error, that the file is locked by another process and can't be accessed. The process that locks these files is "System" process.
Looks like it lock files because of they are in a shared folder, but not sure.
The use of any software to unlock files manually is not an option, as all bulk process is automatic.
The question is: Why the "System" process locks these files and is there a way to prevent this?
