>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.
If it's not broken, fix it until it is.
My Blog 
