December 1, 2007 at 12:06 am
I have defined full text index on two tables in a database.The querying against the database was working fine till yesterday. Then today one of my colleague informed me that the full text search is not
working.I used the
sp_help_fulltext_catalogs
sp_help_fulltext_tables
sp_help_fulltext_columns and was able to get the table and column names participating in the full-text.However if query using the select
or throug the web I am unable to get any rows.
If I query using the Select statement it throws out an error
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. The catalog does not exist or is currently unavailable. Please retry the action again later and if this symptom persists, contact the system administrator.
I am not using any noise words.I am unable to figure it out, both the tables contains around two thousand hundred records. I even started the Full population once but still the error exixts.
December 1, 2007 at 1:39 am
Hi,
--1 Enable Full text indexing on the Database
Exec sp_fulltext_database
--2 Create the catalog (unless you already have)
EXEC sp_fulltext_catalog
--3 Add a full text index to a table
EXEC sp_fulltext_table
--4 Add a column to the full text index
EXEC sp_fulltext_column
--5 Activate the index
EXEC sp_fulltext_table
Check also this old link http://support.microsoft.com/kb/295051
Regards,
Ahmed
--6 Start full population
EXEC sp_fulltext_catalog
December 1, 2007 at 2:46 am
I have already defined the full-text catalog and indexes. I can view
them using
sp_help_fulltext_catalogs
sp_help_fulltext_columns
sp_help_fulltext_tables
however if query using a select statement against that fulltext tables it throws that error. This is happening since yesterday,the same select query was working fine before.
December 1, 2007 at 2:59 am
Hi Ashwen,
check the following links
http://www.dbforums.com/showthread.php?t=393743
http://support.microsoft.com/?kbid=299889
Regards,
ahmed
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply