Storing PDF files in SQL server

[philrm]

HI All
Has anyone ever stored pdf files in sql server? Can it be done as a blob? If so, do I need to write code to do it in a third party produc like VB, or can I use an sql update/insert statment?

 

[DavidJA]

We use A LOT of PDF files here, and a SQL server based job management system. (one or more PDFs per job).

Personaly, I would NEVER store any sort of real data files on a SQL server. We store ours PDF files on the file system with known file names. We have a field in a table which is a GUID column, and we use that for our file names. EG: the path to one of our PDF files is '\\FileServer2\ProofFiles\' + tblProofRevisons.ProofRevisionID + '.PDF'.