After you install the database management system SQL Server, the service for full-text indexing is not turned on by default, so you first need to turn on the service and click SQL in SQL Server Configuration Manager (SQL Server Config Manager) Server services, select the SQL full-text Filter Daemon Lunch, click Properties on the log on lab to see if the service is started, and if it is not, choose to start it in services. And in the Log on Lab interface Select Local System User (local Syetem permissions Max, Net services second, Local Services minimum), reference http://www.cnblogs.com/xwdreame R/archive/2012/07/03/2574747.html
- Two. Add full-Text Indexing Service (for a table)
Add a full-text index catalog to the database instance's storage (storage) Full-text index Full_text catalog test, and then add the table that needs the full-text index to this directory, as follows
Three. View Query results
SQL Server Full-text index creation