To automate the process use this script:

First put the script into a DTS Package ExecuteSQL Task, create the tables using the scripts at the end of the post. Create linked server connections to the...

Agreed but the security advantages associated with the storing the images in the DB are the main motivator here. Also, the last project I worked on where images were...

Thanks - seems that we will be going the way of images stored in Database

It works.

Thanks for all the input - Much appreciated.

I used the script on SQL 2000 on which @@Servername didn't seem to work.

For SQL 7.0,...

Thanks. I'll put the whole thing together now and post the resulting script.

Thanks for response.

I understand why using sp_MSforeachdb would be a good option, So all I have to do is get all the detail out of the temp tables...