The Full-Text Search in SQL allows users or applications to run full-text queries against character-based data in SQL Server tables. However, before doing that you need to perform a full-text indexing to your SQL database. In this article I will give you a step by step guide on how to run a Full-Text Indexing with SQL Server Management Studio

Getting Started

1. Connect to your database using SQL Server Management Studio. If you don’t know how to do that, please watch this tutorial video:

2. Expand the database that you want to run the full-text indexing. Right click on the table that you want to run the indexing, and select the option “Full-Text Index ->Define Full Text-Index“:

4. The Full-Text Index wizard will be displayed. Click “Next” to continue with the process:

5. Select the Unique Index and continue the process:

6. Select the columns eligible for full text queries:

7. Choose the track changes intervals for the table:

8. Set the name for the new catalog, accent sensitivity and index file group. Click “Next” to continue to the final step, where you will see a summary of the wizard. Click on Finish to run the full-text indexing:

9. And that’s it! The full-text indexing has been done!

This Full-Text Indexing with SQL Server Management Studio

Looking for quality Windows Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez