Vieira SQL professional is an excellent resource for sql developers. However I have a need to create a table with pointers to a win 2K directory where image files will be stored (outside the sql database) as Vieira starts to describe in chapter 24. If anyone can help me to do that (write the script) to access the images from the table that provides the directory path and file name I would be most appreicative in learning how to do this as I have a collection of or personal photographs that I want to organize and to display. I have the enterprise edition of sql 2k and have win 2k advanced server along with vb.net professional edition.

Vieira stops short in his discussion on how to do this except to say that using a table to store images of the giff or tiff is so so slow.

Thank you for any help you could give me. Learning how to do this is very important to me.

Jim

How do you want to display them? For example if it's a web page then you just turn the actual path into a URL, there's no need for manipulation of the image data.

--

Joe (Microsoft MVP - XML)

Joe these are not web pages. They are image files from my digital camera in a gif format. I would like to display then in the simplest fashion possible. The author would have us to believe we could display them much like one would display non image data in query analyser. I would imagine that they would have to be viewed in some simple vb.net application. He is so detailed about all of his other topics but his topic all he basically tells us is that internal sql image files are so slow. I hope that helps you. Thank you. Jim