Steps for implementing full text and Directory Search

Steps for implementing full text search.

1).SQL Server Enterprise manager

2).Open Desire server and database (In My case its sq10à Intechnology2

3).Click on tables object

4). Find table named as tbl_content and right click on it

5). Find “Full-text Index Table” and click on “Define full-text Indexing on table” from opened context menu.

6).Popup wizard will appear, click next to it.

7). Verify Unique index is selected as “Pk_Content” click on Next

8).Select check box for “sBody” and “sSubject” from “Available columns” column Click to next

9). Give name “FullTextSearch” for new catalog in Name text box and click next.

10).No Schedule at the moment just press to next

11). Press finish

12). Click ok to new popup.

13). Switch to Full-text Catalogs for current database (In our case Intechnology 2)

14) Select catalog “FullTextSearch” Right click on it and “Start full population”

For Directory Search

1). Goto run type “compmgmt.msc” click ok

2). Click on “Services and Applications” and find out “Indexing Service” (You required right for Indexing service if you can’t see “Indexing Service”, Please contact to your administrator.)

3).Right click “Indexing Service” à New à Catalog à Give name to your catalog and place select location for placing catalog search indexing on Hard drive and click on “OK” also click “ok” to message.

4). Select your recently added Catalog à Click on Directory à Right click to it Select àNew à Directory from Context menu.

5).Browse the path for Documents to indexing.

e.g. “D:\Maulik\Projects\Intechnology 2.0\Documents”

6). Verify “Include in Index?” radio button Set to “Yes”, click ok

7). Right click “Indexing Service” and click on “Stop”

8). Right click “Indexing Service” and click on “Start”

9). Select your recently added Catalog à Right click on it à Property from Context menu.

10).From Property popup Select 3rd Tab “generation”

11).Uncheck “Inherit above setting from services”

12) Check rest of two check box named as “Index files with unknown extension” and “Generate Abstracts” and click to “OK”

13).Select your recently added Catalog and click on Property find out “Characterization” and Double click on it.

14). Checked “Cached” checkbox and give size to 100 instead of 20 from opened popup window and click on OK. Click Ok to message.

15). Right click “Indexing Service” and click on “Stop”

16). Right click “Indexing Service” and click on “Start”

18). Select your recently added Catalog click to Directory and select your browsed document path from detail pane.

19).Right click on it select à All Taskà Rescan (full). Say “Yes” to message.

20). Please verify your catalog by Selecting “Query the catalog” and search for desires text.