Full-Text Indexing with SQL Server Management Studio

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:

opening sql server management studio arvixe tutorials asp hosting

connecting to database sql arvixe tutorials

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“:

define full text index arvixe tutorials sql tutorials

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

index wizard sql arvixe tutorials sql windows hosting iis websitepanel

5. Select the Unique Index and continue the process:

select index pk personal arvixe sql tutorials asp blogs

6. Select the columns eligible for full text queries:

select columns arvixe asp tutorials websitepanel sql

7. Choose the track changes intervals for the table:

track changes sql database arvixe tutorials

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:

catalog filegroup and sensitivity arvixe websitepanel tutorials sql

Finish wizard sql arvixe

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

full index done sql arvixe tutorials

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

Tags: , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 3.5, DotNet/Windows Hosting, DotNetPanel Administration, WebsitePanel Tutorials | RSS 2.0

Author Spotlight

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

Leave a Reply

Your email address will not be published. Required fields are marked *