>>>Hi,
>>>
>>>I'm working on a system where the user wants to scan documents and store them in a database. I'm guessing at this point that scanning will be to a TIF or JPG, but am wondering if they may be able to scan to a PDF. What would be the best field type to store these scans?
>>
>>You have a few options.
>>
>>1. Only store a path to the file in SQL Server (this is the same suggestion as using VFP tables)
>>
>>2. Use VARBINARY(max) field
>>
>>3. Use new (SQL Server 2008) FileStream option.
>
>Thanks. Which option would you recommend?
See also
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/bdd79bcd-f9f5-419f-ade4-dd3ff4ab8455
If it's not broken, fix it until it is.
My Blog