komal145 (8/24/2016)
It runs fine with all the SQL agent owner when i diable to task which copies the file to a archive folder. This can be done in Dev enviornment ( both BIDS and dev server). But when I try as a job IN UAT , again the file gets locked. What can be done ,if we don't want the file to be locked?
Again, probably a privs problem. Does the SQL Agent Service login have privs to do such a thing where you need to do it?
--Jeff Moden
Change is inevitable... Change for the better is not.