At the moment, "Host Settings / Host Setup / Use file table" isn't ticked so our attachments are all stored as files in the uploads folder.

I'd like to change this, and store the attachments in SQL server, mainly so that I can use full-text search on PDFs.

I assume that this means that yaf_Attachment.Filedata will need to be populated with the file contents. Does anyone already have a script that will do this?

But when you store attachments in the db you wont be able to search through such files. The files are stored as raw data

update yaf_Attachment 
set FileData=
   (select pdf.bulkcolumn from openrowset(bulk 'E:\temp\Newsletter 2014-2.pdf',single_blob) pdf )
where AttachmentID=172

[FileType]  AS (lower(reverse(substring(reverse([filename]),(1),charindex('.',reverse([filename])))))

 select * from yaf_Attachment where contains(FileData,'flooding')