TO Find SIZE OF FILES (LIKE JPEG,DOC) Using SQL

Question

TO Find SIZE OF FILES (LIKE JPEG,DOC) Using SQL

sgovindakrishnan

Grasshopper

Points: 18
More actions
August 6, 2009 at 4:21 am

#224605

I Want to Find the Size of Some Files (LIKE JPEG,DOC) Using Sql Query..

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

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

free_mascot One Orange Chip Points: 27164 More actions · Answer 1

use xp_cmdshell

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

JamieX Hall of Fame Points: 3763 More actions · Answer 2

your other options:

CLR SP

http://stackoverflow.com/questions/214698/file-path-size-in-c

OLE automation object

http://www.databasejournal.com/scripts/article.php/3443911/Check-File-Size.htm