Find Large Files on OS - Results of DIR to Table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bhunter1 » Find Large Files on OS - Results of DIR to...

Find Large Files on OS - Results of DIR to Table

Rate Topic

Display Mode

Topic Options

Author

Message

Congruent Influence

Posted Thursday, June 05, 2008 8:19 PM

Valued Member

Group: General Forum Members
Last Login: Friday, May 10, 2013 10:39 AM
Points: 70, Visits: 135

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.

Post #512631

dlazov

Posted Wednesday, July 23, 2008 11:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 17, 2010 9:06 AM
Points: 1, Visits: 20

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

Post #539527

« Prev Topic | Next Topic »

Permissions