Determining the size of embedded images

The SQL queries demonstrate how to show the amount of space that each BLOB field is consuming. Both of these queries return the size of the field in bytes.

SQL Server


SELECT BLOB_ID, DESCRIPTION, FILE_NAME, 

DATALENGTH(OBJECT_DATA)

FROM FSEMBEDDEDOBJECTS