>>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?