Using FullText search with FileTables in SQL Server 2012

  • Article

In my previous post sometime back I talked about FILETABLES,  [link] . This is a new feature introduced in SQL Server 2012, which is built on top of FILESTREAM.

I also talked about how we can use them to store files and retrieve the information from them.

 

Here, in this post we will see how we can search in the files stored in FileTables using an existing feature i.e.  “FullText Search” .

So, let’s check this by an example. I’ll be using the same code from my previous post to create a new Database and Filetables.

 

Check here for full details.