Full Text Search in SQL 2005

I issued the commands 

USE MyDatabase

EXEC sp_fulltext_database  'enable'

"At this point, the Full Text Search was available in the Management Console"

From here in TSQL :- 

--1  Create the catalog (unless you already have)

EXEC sp_fulltext_catalog   'FTCatalog','create' 

--2  Add a full text index to a table 

EXEC sp_fulltext_table     'Departments', 'create', 'FTCatalog', 'pk_departments' 

EXEC sp_fulltext_table     'Employees', 'create', 'FTCatalog', 'pk_employees' 

--3  Add a column to the full text index 

EXEC sp_fulltext_column    'Departments', 'ProductName', 'add' 

EXEC sp_fulltext_column    'Employees', 'Description', 'add' 

--4  Activate the index 

1 EXEC sp_fulltext_table     'Departments','activate' 

2 EXEC sp_fulltext_table     'Employees','activate' 

--5  Start full population 

EXEC sp_fulltext_catalog   'FTCatalog', 'start_full' 
posted on 2009-09-15 13:21  collinye  阅读(152)  评论(0)  编辑  收藏  举报