problem with enabling the fulltext search

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

problem with enabling the fulltext search

Author

Topic

phill25
Starting Member

1 Post

Posted - 2007-03-09 : 16:38:22

Hello,
I try to get the full-text search on SQL Server Express with advanced Services SP2
running, but I got some problems.
First I tell you what I did.
I created a new database called TestDB.

Then I created a TestTable inside the db with a Primary Key:

CREATE TABLE [dbo].[TestTable](
[id] [int] IDENTITY(1,1) NOT NULL,
[text] [ntext] COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Then I executed these commands:

sp_fulltext_database enable
create fulltext catalog testcatalog as default
create fulltext index on TestTable(text) key index PK_TestTable

Now the problem:
When I insert some rows in the Table the catalog get not populated.
(change Tracking Setting is set to auto)
Instead these error messages are written into the crawl log:

Error '0x80004005' occurred during full-text index population for table or indexed view
'[TestDB].[dbo].[TestTable]' (table or indexed view ID '2073058421', database ID '5'),
full-text key value 0x00000002. Attempt will be made to reindex it.

The component 'sqlfth90.dll' reported error while indexing.
Component path 'c:\Programme\Microsoft SQL Server\90\COM\sqlfth90.dll'.

Can somebody give me a hint?

Greetings,
Phillip

Dennis
Starting Member

11 Posts

Posted - 2007-03-20 : 09:45:11

I get the same problem....any help out there?

solidroots
Starting Member

1 Post

Posted - 2009-04-17 : 03:39:49

Hi Friends,

I am working in SQL Sever 2005 express with advance services. I created a full text catalog and a full-text index. I created it using WITH CHANGE_TRACKING AUTO. But if i make changes to the data of the column then the full-text index is not updating itself automatically. I am able to update the fulltext index using ALTER FULLTEXT INDEX ON tablename START UPDATE POPULATION and it populates fine but it does not populate automatically after an update.
In the log file the error is same:

Error '0x80004005' occurred during full-text index population for table or indexed view '[databasename].[dbo].[tablename]' (table or indexed view ID '1268199568', database ID '5'), full-text key value 0x00000053. Attempt will be made to reindex it.

The component 'sqlfth90.dll' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\90\COM\sqlfth90.dll'.

Please help. Please share how were you able to overcome this problem.

You can have full background of this at http://www.sqlservercentral.com/Forums/Topic698295-324-1.aspx

Thanks and regards
solidroots

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources