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

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to find a root folder where data are stored.

Author  Topic 

vinylpimp
Starting Member

16 Posts

Posted - 2013-01-18 : 14:14:01


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

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-01-18 : 14:33:12
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 - 2013-01-18 : 14:53:32


I found that 'supplierimageid' is = 'imageid'

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

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-01-18 : 17:22:43
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
   

- Advertisement -