>>>Anyone think of a way to look at the files in one directory, compare it to the files in another directory, and return a list of what's missing?
>>
>>Just wondering if this has to be done in SQL Server. I think you can easily do this in VFP.
>
>Yes I could, but no VFP available or is allowed to be loaded.

Don't know if any of the listed tools on that site would work for you.

http://www.dirfile.com/freeware/compare-files.htm