In earlier versions of SQL, we would have to right-click on the table we wanted to have full text index search capabilities by going to Design. Once in the table designer, we would choose Full Text Index and we would set the values in the window that would pop up.
In SQL 2008 R2, however, the process of setting up the full text index search is as follows:
The very first step is to create a new Catalog in our data base as follows (Let's not forget to click on the Data Base we want to setup the Full Text Index Search)
CREATE FULLTEXT CATALOG NameOfCatalog
Execute the stored procedure, which should be really quick and in where we should get a message like this:
Command(s) Completed Successfully
Then we go through the following steps:
1- Right Click the table we want to setup full text index search and then we go to Full-Text index and then choose Define Full-Text Index
2- The wizard opens.
3- Click next - The Primary key (index) of the table will be pre-populated
4- Click next - Here we would choose the columns we want to be searched. In my case, I'm choosing Description and Name.
5- Click next - Here we choose to have SQL update the changes done to the Table Automatically.
6- Click next - Here we select the catalog we want to use for the Full Text Index search (This is the one we created at the beginning of this article)
7- Click next - To define the population I believe we need to have SQL Server Developer or Enterprise. (I left this blank)
8- Click next - Then w see the summary.
9 - Click finish and we will get the following confirmation (This should run fairly quick)