Home Forums SQL Server 2005 T-SQL (SS2K5) Scripting help - Need a query to find filenames and filepaths under a certain directory RE: Scripting help - Need a query to find filenames and filepaths under a certain directory

  • Heres the table:

    CREATE TABLE [dbo].[tblSaveFilePathAndName](

    [filePath] [varchar](1000) NULL,

    [fileName] [varchar](200) NULL

    )

    Purpose: We have thousands of files that we need to sort through and find, and quickly identify where those files are located.