Is it possible to modify Tiff tags in images stored in image fields?

[RAS56]

We have a bunch of .tif images stored in records with an image field. We are needing to update/add a tif tag to each of these images. Can anyone point me towards any libraries or methods of doing this server side and not have the overhead of moving the files across the network, modifying the file on the client and then writing the image back to the db?

I know it isn't recommended that images be stored in blob fields but unfortunately, we have this implementation in place and don't have the option of changing the paradigm at this point.

Thanks for any assistance.

 

[mrdenny]

I would assume that the safest method for editing a binary field such as an image would be to move it to a client then have it make the change then write the change back.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[RAS56]

Right, I realize that extracting the image to the client, writing the tif tag and then overwriting the image back to the blob is probably the most straigtforward but it incurs a lot of overhead in terms of network traffic. Potentially, we could need to do this to thousands of images frequently and was hoping there was perhaps some kind of .dll or something I could use to have SQL do this with a function server-side. Is that even possible?

Thanks,
Richard