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'
MarryPosted Aug 27, 2007, 7:58 AM
if you can help me ill be very thanksfull the following is my email [email protected] Kind regards Taj
MarryPosted Aug 27, 2007, 7:56 AM
Hi very nice article and it helped me to a certain point. i want to implement a full-text search using stored procedure and i cant use the local variable (@MySearch) i tried to replace the local variable with '" +@MySearch+"' and the sql server write an error which says incorrect syntax near '.' how do i resolve this problem?