View image stored in VARBINARY(MAX) column in SQL SERVER 2008

Question

Hello,

How to select and view the .jpg image stored in VARBINARY(MAX) column in SQL SERVER 2008?

Thanks!

Answer 1

Hallo Anonymous,

for viewing the jpg you need to have a client (i.e. Microsoft Access).
SQL Engine only stores the data!

Just a good example with .NET is described here:
http://msdn.microsoft.com/en-us/library/vstudio/cc716724.aspx

---

Uwe Ricken

MCITP Database Administrator 2005
MCITP Database Administrator 2008
MCITP Microsoft SQL Server 2008, Database Development

db Berater GmbH
http://www-db-berater.de
SQL Server Blog (german only)

Answer 2

There is a free software called SSMSBoost which is an extension for SSMS.
This allows to view the image right from SSMS.

Another way to view the image is to export it from table to file system using bcp command.
Below link explains how to do that:
http://madhuottapalam.blogspot.com/2008/08/creating-files-from-images-stored-in.html