SQL Server: How to Check the Status of a File Before Processing

MAK demonstrates how to use the user defined function, udf_CheckFileStatus, to avoid waiting for a file to be copied and how to run a process more efficiently.

http://www.databasejournal.com/featu...le.php/3492046