OTF (9/13/2012)

---

To by pass OLE Automation which you would typically want to do anyway you can put code along these

lines in a SQL CLR Function to test for the readiness of a file to be read:

try

{

using (File.Open(filepath, FileMode.Open, FileAccess.Read, FileShare.None)) { }

}

catch (Exception)

{

return false;

}

return true;