Can anyone point me to any good articles about storing and retrieving .pdf files in sql server 2005? Preferably something in C#. I haven't found much on google. Thanks.
This is not a good idea. Much better is to store the pdfs on the file system, and store a path to the file in sqlserver. See this article (note that the article applies to images, but all the points are the same as you would have to use an IMAGE column to store a pdf):