>>>For SQL 2008 I'd recommend the option 3, although I personally haven't worked with it.
>>
>>Same here - I would go with 1 or 3 (I haven't tried 3 yet) - but you sure don't want to use option 2.
>
>Thanks Viv,
>
>what's the problem with VARBINARY(max)?
Not much of a problem except for the fact it makes a lot of storage, so you may want to plan accordingly - say, put this Table with images on a separate file group.
If it's not broken, fix it until it is.
My Blog