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.

2002-03-05

455 reads

Blogs

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Things to look out for while TDE is encrypting existing data

By

Monitoring for Problems The encryption of your existing data occurs as a background process...

Read the latest Blogs

Forums

ROUND or CONVERT the output of the POWER function

By Chrissy321

Hello smart people, I am trying to use the POWER function to return data...

Weird Log Backup Failure message

By Lee Linares

I found the same error message in the SQL Error log on 3 dozen...

Roles in cluster

By PJ_SQL

Hello! When we failover one node from another, does the roles from the node...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers