Hi all,
I am troubleshooting a problem where an INSERT-SQL is failing due to "File access is denied." I am at a loss as to how to trace the cause of the problem as it happens intermitently. The file in question has a very high access (READ/WRITE) rate. I've asked our client to moniter the table using a 3rd-party utility but the log gets so huge rather quickly and the process is manual.
I am looking at putting the INSERT-SQL inside a try/catch and when the problem happens; capture the Open Files data and log it so I can hopefully find out the process that has the table locked. The Open Files that I'm talking about is the list one would see if you right-click on
My Computer->Manage->System Tools->Shared Folder->Open Files
using Win32 API.
1. Can anyone point me to a similar solution using Win32 API? I am still looking around for the method that will allow me to get this information.
2. Can anyone suggest another approach on how to troubleshoot/log the problem?
3. What happened to the Win32 API section in UT?
ramil
~~ learning to stand still