>A different way of doing this is to store the images on disk, and store a path to the image in sql. This way you have a simpler method of storage/retrieval, and do not have to use resources of your database to house the images.
>
>
>
>>I am attempting to store fax images (.TIF) to a SQL Server image column, and be able to restore the images to a .TIF file and process them in the Kodak ImageAdmin viewer.
>>
>>I have successfully stored the images to SQL (at least it seems as though I have done so) but have had little success extracting them from SQL.
>>
>>I have tried many different approaches that were far from effective.
>>
>>Any assistance would be greatly appreciated.
That is what we are doing now. The main problem is bandwidth constraints over a WAN. There seems to be a lot less problems with bandwidth comparing SQL vs. copying files over the WAN. Even though these files only occupy 30 - 50 Kb, they can clog up a WAN quite quickly. At this point, SQL resources are a far less problem than bandwidth.
Bill Benton
Senior Systems Analyst
Nuvell Financial Services