SQL FILESTREAM ISSUE

[BFT1303]

I am new to using the filestream.
I am trying to open a pdf from the table that I have stored in SQL Server 2008 with filestream.
I would also like to attach it directly to an email.

Any direction would be greatly appreciated.

Thank you,
Brad

 

[mrdenny]

You access the data from the filestream just like it is stored in a normal varbinary(max) field. I believe that in order to send it as an email you'll need to use a Windows app to take the value and send it. I don't believe that sp_send_dbmail can handle putting the data back into a pdf file.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog