Home Forums SQL Server 2005 SQL Server 2005 General Discussion Get date last modified for file RE: Get date last modified for file
Steve Jones - SSC Editor
SSC Guru
Points: 734449
More actions
May 6, 2008 at 10:13 am
#811320
sp_OACREATE and use the filesystem object to snag things.
Parse an xp_cmdshell 'dir' result set.
Or even write a VBScript that can get the infromation and insert it into your table (I'd probably do this).