Find Large Files on OS - Results of DIR to Table

• Congruent Influence

  Default port

  Points: 1416

  More actions

  June 5, 2008 at 8:19 pm

  #188721

  Comments posted to this topic are about the item Find Large Files on OS - Results of DIR to Table

  Remember this when a developer tells you it will just be temporary. Temporary = Permanent.

• dlazov

  Grasshopper

  Points: 21

  More actions

  July 23, 2008 at 11:33 am

  #847244

  This looks to be an excellent utility. However, on my server when I run the exec for the SP I get the following error message:

  Msg 8114, Level 16, State 5, Procedure RecordLargeOSFiles, Line 99

  Error converting data type varchar to bigint.

  The part of the SP that seems to have issues is:

  select #FilePaths.FilePaths, #FilePaths.[FileName], Convert(BigInt, FileSize) FileSize, Convert(DateTime, FileDate), GetDate()

  from #FilePaths

  join #FileScan on Rtrim(Ltrim(#FilePaths.[FileName])) = Rtrim(Ltrim(#FileScan.[FileName]))

  where Convert(BigInt, FileSize) > 10000000000