Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find Large Files on OS - Results of DIR to Table Expand / Collapse
Author
Message
Posted Thursday, June 5, 2008 8:19 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:42 PM
Points: 70, Visits: 145
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
Posted Wednesday, July 23, 2008 11:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse