I've found two extended stored procedures that may be of help: xp_dirtree & xp_fileexist.

-Mike

>I have need to verify the existance of ANY file in a specific folder on a 2000 SQL Server
>
>Issue is generating an email to an ower of a DB in our system when we run across an error in their data. We can generate a text file that describes it. I want to now run an ADIR() for that file so I can email them all of these files at once or one at a time??
>
>I want name, and date/time that is why I mentioned ADIR()
>
>Anyone know how to delete these text files after the fact? Or do a winzip pass to archive and then move.