>>>Why do you think I am not using filestream?
>>
>>Because the samples on the filestream page are confusing. They are not using blob syntax.
>>BOL reference about FileStream
>
>I was following this example:
>
>http://www.sqlservercentral.com/articles/FILESTREAM/67668/
>
>However, I am a little concerned now. I thought that I should see a file in the folder that I set up as the path for the files to get stored that I can then open with Adobe reader. There is a file there but when I try to open with Adobe Reader it says it can't.

I see. I asked a bunch of related questions here
http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/4ba7d298-c853-4fe7-995c-ce75e5ff767f

I'm going to play with it a bit later this week.