Storing Image to SQL server...

[Smallkeung]

Now, I'm writing a system which requires to show images. I know that SQL server supports to storing image file and I would like to know that is there any bad points or problem to store image into SQL server? if yes, any other suggestion?

Now, my method is storing the image path into SQL server, but I find that it is very difficult to maintain. e.g. someone may delete the image by some other program but the path is still keeping in the database.

(One known problem for storing image into SQL server is the size of SQL server, it will be very big.)

[gauravmarwaha]

Hi,
Yup U can store images using the binary objects in SQL server. But donot use these on the web. It gets toooo slow. And to load these U got to use an OCX which U can check out by posting a question to the Microsoft at their web site. (At least this is what they told me!!)
The easy way out is to store the path to the image in the database and use the LoadPicture method on that path

Ciao