Over the next few days we are going to start the migration to a new forum
application. I'm going to start with high post count and active users. You may
receive an invitation to the new forums. It's not spam. It's just me trying to
seed the user base. My goal is to open it up over the weekend.
Once we open the site we'll block registrations here. We should be open
shortly on the new site.
I must check if all files from C:\Import\*.doc were processed and imported in to a database Table Filename. If the Filename exists in the Table Filename then it can be deleted from the Folder C:\Import otherwise the file must remain in the folder. Can anyone Help me ?
Yes it can be done by T-SQL, but that doesn't mean that it should be. xp_fileexists is undocumented by Microsoft in Books Online. There are better ways of achieving what you want. Application code, Powershell, SSIS for instance.