Ho Do I find List of file names on specified location in SQL Server

[Prashant Mishra]

Is there any way or Sql Statement to find out the list of file name from a specified path.

I want to provide a path of a folder (e.g. d:\prashant\) and Sql Statement or program should return all file names available in the d:\prashant\.

[Rabbit]

If you input all the files, folders, and paths into a database table then yes. But I don't understand why you would want to do that much work or why you would want to store a replica of your filesystem in a SQL table.

[ck9663]

Do a simple "dir" in a xp_cmdshell statement. Make sure to store the result into a table.

Happy Coding!!!


~~ CK

[ck9663]

Do a simple "dir" in a xp_cmdshell statement. Make sure to store the result into a table.

Happy Coding!!!


~~ CK