Hi,

I am using FileStream in my SQL Server 2008 R2 database to store a PDF. I use this code:

UPDATE Claims
	SET clm_Scan = CONVERT(VarBinary(max), N'MyFileName.pdf')
	WHERE clm_PK = 'MyPK'

I want to let the user now view the PDF, so I query the clm_scan field then use STRTOFILE() to create the file oon my disk, but when I try to open the PDF I get a message that "Adobe Reader could not open the file because it is either not a supported file type or because the file has been damaged..."

Am I doing this right?