How to retrieve/check filename from SQL Server

[SarahG]

Hi
I want to create a stored procedure which will check a directory, see if there are files in it and if so, will return the filenames. I know I can do it through Access but is there a way to do it from SQL Server, something similar to xp_cmdshell perhaps?

 

[hmckillop]

xp_fileexist will check if a file exists, not sure if it does for directories though.
There are others like xp_dirtree and xp_dirinfo, some of these might help.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[SarahG]

Thanks a million, these aren't listed on Books online, I just assumed everything was.