• 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