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