Find Large Files on OS - Results of DIR to Table

  • 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.

  • 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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply