Find image size of image data column in MSSQL

I want to determine the size of the image I've uploaded into my MSSQL image data column. When I view the table in the SQL Server Enterprise Manager it only shows this: "<Binary>" and does not give any other information. I need to make sure my image script is actually uploading the image correctly, and I'm trying to do this by finding out the actual length in bytes of the image. Thank you in advance for any help.

Here's my @@version string:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Standard Edition NT 5.2 (Build 3790: Service Pack 2)
shady1024Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
James MurrellConnect With a Mentor Product SpecialistCommented:
SELECT DATALENGTH(image) FROM schematicsimage
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
please check out the DATALENGTH() function:
http://technet.microsoft.com/en-us/library/ms173486.aspx
0
 
shady1024Author Commented:
Thank you. I had seen an article that said use the data_length() function, which did not work. Now I see there's no underscore in the function name. Again, thank you very much for your prompt responses.
0
 
James MurrellProduct SpecialistCommented:
Thanks happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.