To get the Size of an Image Type field

The following sql script allows us to view the size of an image type column in Sql Server 2005.

//Image datatype column - To find the length of the image/blob field
SELECT DATALENGTH(GroupLogo)
FROM dbo.[Group]

The script will display the size of "Group Logo" (Image file uploaded to db earlier) in bytes..

Hope this will help you showing the file size before downloading

M. Sreekanth