Storing Images And Files In Sql Server An Alternative?

Hi,

I was wondering what anybodies feelings on storing images and files in SQL server express 2005?

I am guessing it is a No No...

If this is the case what are the best practices for achieving this?

Would something like a table which held the "real name of the file", "a unique identifier" do the trick...


hence in code (c#) i could create a GUID for the unique identifier maybe??? and then upload the pictue or file to a common directory and name it with the unique identifier rather than its real name.

This means that i could potentially hold a different file with the same name i.e. no conflicts

My app is a sort of HTML editor in asp.net (all html is stored in the db) so if i do upload a picture using a GUID or uniquee identifier then if somebody saves teh image from a webpage then it would be called uniqueIdentifier.jpg which is probably what i don't want.

So the only other idea i had was to create a directroy within my site which I would name with the unique identifier and upload the pics and files with thier real names into this directory. Hence each document would have its own directory so there would be no conflicts with filenames

Any advice or comments really appreciated


Thanks in advance

Ian