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