Technical Article

Populate a table with a directory's file info.

I use this SP to return full directory information into a table.  FilePath, FileName, Filedate and FileSize are parsed from a 'dir /n/on/-c ' command. FilesInDir is the table created. usage: exec LoadFileDetailsIntoTable 'c:\winnt'select * from FilesInDir where filesize > 100000select min(fileDate) from FilesInDirThe Return Code will equal the number of files found.

You rated this post out of 5. Change rating

2002-03-05

457 reads

Blogs

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Read the latest Blogs

Forums

CXConsumer wait type issue

By saum70

hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000...

How to speed up this?

By water490

Hi everyone One of my SSIS components seem to be very slow.  I am...

Managing some particular dimensions in a data warehouse based on medical records

By pmscorca

Hi, I need to design a data warehouse solution to manage medical records about...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers