>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.
If it's not broken, fix it until it is.
My Blog