Friday, November 16, 2012 11:31 PMHello,
How to select and view the .jpg image stored in VARBINARY(MAX) column in SQL SERVER 2008?
Saturday, November 17, 2012 12:58 AM
There are number ways to see a image stored in database.But none are built in functionality of Management studio.
1. You can use power shell to export images from sql server.Following posts has relevant information.
2. You can use export Column task in SSIS to import a image column to a file.
3. You can use some asp.net code
There are some third party add ins(ssmsboost) to management studio to add image viewers to context menus of image column in the result set.I haven't tried this.
My advise is to use power shell.
Vinay Valeti| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer
Saturday, November 17, 2012 1:17 AM
SSMS has no such functionality, you can use third-party products that do that in your IDE's.The EMS IDE has this functionality, you can use the free version or trial.
Or if you need to do with a specific programming language, specify it.
Monday, November 19, 2012 8:29 AM
SSMSBoost plug-in for SQL Server Management Studio has this feature:
SSMSBoost - ssms add-in adds quick source code navigation to SSMS, quick connection management & switching, shortcuts, auto replacements and object search. www.ssmsboost.com
Monday, November 26, 2012 9:17 PM
Boost worked perfectly.
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:
Monday, April 08, 2013 7:35 PM
we can also use SSRS to view the image stored in the SQL Database.
Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com