Let us discuss the steps for implementing full-text search
in SQL Server 2005.
·
Adding a full text search catalog to the database – To add a full
text search catalog we need to open the database node in Management studio and
click on the storage node. We can see the Full text catalog in this node. We
have an option for adding the full-text catalog by which we can add a new
catalog.
·
Adding the Full text indexing table – We need to specify to the
database that we want to implement the full-text search functionality for a
table. To do this we can select the respective table and select the right click
option of Full-Text Index and Define Full-Text index. This opens up the Full
text indexing wizard.
1.
Using the Full text indexing wizard we select a unique index.
2.
Once we select a unique index and move to the next step, we select the
columns that are eligible for full text queries. This enables the full-text
search for the selected columns.
3.
We need to select the option of how can we track the changes. If
automatically selected then a full population of indexing occurs. To avoid a
population at the end of this wizard, select the Do Not Track Changes option,
and clear the Start Full Population When Index Is Created checkbox.
4.
Once we are done with step 3 we need to map the catalog out of all the
catalogs at the database level. Or we could even create a new catalog for the
full text search.
5.
This is the last step of the wizard. Here we can create a table schedule
and catalog schedules and schedule them with time. A table schedule can have a
name, time of schedule and occurrences.
Once we create
them and click on the finish button the full-text index is created.
