Well - so far I've written a down-and-dirty little VB app that wildcard searches through a folder with 10000 jpgs and loads them into the VARBINARY(MAX) field of this new table.

I've only loaded two images for testing so far - I want to nail down some of my questions and issues before putting 1.5 GB through the TRANSACTION LOG file! The person in charge of the photo folder on the network share is going to look into bulk dropping the filesize of some of the JPG's - they are very nice images - we don't need such heavy and large images.

The whole reason we are doing this is because we are about to release about 100 POCKET PC's that use MS SQL CE. We discovered that there was no easy native-way to encrypt an image on a PPC (zip namespace left that out on the compact framework!). But MS SQL CE does encrypt - so as long as the images are in the DB then encryption comes along as part of the package.