Home Forums SQL Server 2005 Development Pulling Filename from Windows directory into table RE: Pulling Filename from Windows directory into table

  • Jeff,

    Your SP is exactly what I've been looking for.

    I just have one problem. I can't seem to find the temp table it created.

    Is the table somehow dropped after running the SP?

    when I try to execute the following:

    SELECT * FROM #FileDetails

    Results

    Msg 208, Level 16, State 0, Line 1

    Invalid object name '#FileDetails'.

    I'm using SQL Server Express 2005 and I'm kinda new to SQL

    I'm looking to get the filenames and attributes into a permanent table to automate alot of manual work.

    I also do not want to delete the filename from the table, just append to it if the filename doesn't already exist.

    Thanx in advance Jeff and hope you can help