SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to find a root folder where data are stored.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vinylpimp
Starting Member

16 Posts

Posted - 01/18/2013 :  14:14:01  Show Profile  Reply with Quote


column 'Supplierimageid' contain some Jpeg files, but I cannot find it anywhere on my server.

Is there a way I can trace where these data are stored?

Many thanks,

Hon

Edited by - vinylpimp on 01/18/2013 14:15:02

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 01/18/2013 :  14:33:12  Show Profile  Visit robvolk's Homepage  Reply with Quote
The column contains numbers, not actual JPEGs. There's no way to know where (or even if) they are stored, unless you have a SupplierImage table that correlates the ID to the image path.
Go to Top of Page

vinylpimp
Starting Member

16 Posts

Posted - 01/18/2013 :  14:53:32  Show Profile  Reply with Quote


I found that 'supplierimageid' is = 'imageid'

Are we closer to finding the path?
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 01/18/2013 :  17:22:43  Show Profile  Visit robvolk's Homepage  Reply with Quote
The image data seems to be stored in ImageFull but you'd have to save it to a binary file and open it in a program that supports it.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000