Full Text Search on SQL 2000

To enable fulltext search on a database on SQL server 2000 execute the following SP in query analyser.

exec sp_fulltext_database 'enable'

Other useful SPs that can be helpful in fulltext search

/*This will return the version on MSSQLServer:*/

SELECT SERVERPROPERTY('productversion')

 

/*This will return the service pack information of MSSQLServer:*/

SELECT SERVERPROPERTY('productlevel')

 

/*This will Full Text Search component is installed or not:*/

SELECT SERVERPROPERTY('IsFullTextInstalled')

 

/*This will show - is current database is full-text indexed:*/

select DatabaseProperty(db_name(), 'IsFulltextEnabled')

 

/*This will enable full-text indexing for the current database:*/

exec sp_fulltext_database 'enable'

 

/*This creates a catalog:*/

exec sp_fulltext_catalog 'catalogname', 'create'

 

/*This enables indexing of a table:*/

exec sp_fulltext_table 'tablename', 'create','catalogname', 'indexname'

 

/*This adds a column to an index:*/

exec sp_fulltext_column 'tablename', 'columnname', 'add'

 

/*This activates fulltext on a table:*/

exec sp_fulltext_table 'tablename', 'activate'

 

/*These two enable automatic filling of the full-text index when changes occur to a table:*/

exec sp_fulltext_table 'tablename','start_change_tracking'

exec sp_fulltext_table 'tablename','start_background_updateindex'


Similar Articles