Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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.
 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
15732 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
15732 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  
 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.03 seconds. Powered By: Snitz Forums 2000