SQL Server 2005 with advanced services and full text search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scottoliver06@gmail.com - 18 Oct 2007 13:26 GMT

I would like to see if anyone knows what the prereq's are to install
sql 2005 advanced and to be able to use the full text indexing
capability. I have just a xp workstation. I have IIS running. I
install full text per video 13 on microsofts education site but it
does not work. if I run a search using contains or freetext the
results just come back empty in grid view with the name of the colms
at the top. Does sql 2005 need the microsoft search service because I
do not see that service installed? Any help would be appreciated.
Thanks.

Reply to this Message

Hilary Cotter - 18 Oct 2007 16:50 GMT

For some reason it is not indexing. But it appears to be working.

Can you check the gatherer logs found in your log directory to see what they
report?

Also did you kick off a full-population?

>I would like to see if anyone knows what the prereq's are to install
> sql 2005 advanced and to be able to use the full text indexing
[quoted text clipped - 5 lines]
> do not see that service installed? Any help would be appreciated.
> Thanks.

Reply to this Message

scottoliver06@gmail.com - 18 Oct 2007 19:02 GMT

OK
I re did video 16 named everything the same did exactly what the video
did and it worked but when I tried to recreate it using my database it
does the same thing. here is the log from the index I dont know what
any of it means

2007-10-18 11:22:07.96 spid26s Informational: Full-text Full
population initialized for table or indexed view '[RSDB2].[dbo].
[support]' (table or indexed view ID '2105058535', database ID '6').
Population sub-tasks: 1.
2007-10-18 11:22:07.96 spid26s Informational: Full-text Full
population completed for table or indexed view '[RSDB2].[dbo].
[support]' (table or indexed view ID '2105058535', database ID '6').
Number of documents processed: 0. Number of documents failed: 0.
Number of documents need retry: 0.
2007-10-18 11:22:07.96 spid26s Changing the status to MERGE for
full-text catalog "rsCatalog" (5) in database "RSDB2" (6). This is an
informational message only. No user action is required.
2007-10-18 11:22:08.95 spid26s Informational: Full-text Auto
population initialized for table or indexed view '[RSDB2].[dbo].
[support]' (table or indexed view ID '2105058535', database ID '6').
Population sub-tasks: 1.
2007-10-18 11:42:11.15 spid25s Error '0x80040e09' occurred during
full-text index population for table or indexed view '[RSDB2].[dbo].
[support]' (table or indexed view ID '2105058535', database ID '6'),
full-text key value 0x00000002. Attempt will be made to reindex it.
2007-10-18 11:42:11.15 spid25s The component 'sqlfth90.dll'
reported error while indexing. Component path 'c:\Program Files
\Microsoft SQL Server\90\COM\sqlfth90.dll'.
2007-10-18 11:42:12.15 spid25s Error '0x80040e09' occurred during
full-text index population for table or indexed view '[RSDB2].[dbo].
[support]' (table or indexed view ID '2105058535', database ID '6'),
full-text key value 0x00000002. Attempt will be made to reindex it.
2007-10-18 11:42:12.15 spid25s The component 'sqlfth90.dll'
reported error while indexing. Component path 'c:\Program Files
\Microsoft SQL Server\90\COM\sqlfth90.dll'.
2007-10-18 11:42:12.15 spid25s Error '0x80040e09' occurred during
full-text index population for table or indexed view '[RSDB2].[dbo].
[support]' (table or indexed view ID '2105058535', database ID '6'),
full-text key value 0x00000002. Attempt will be made to reindex it.
2007-10-18 11:42:12.15 spid25s The component 'sqlfth90.dll'
reported error while indexing. Component path 'c:\Program Files
\Microsoft SQL Server\90\COM\sqlfth90.dll'.
2007-10-18 11:42:15.13 spid25s Error '0x80040e09' occurred during
full-text index population for table or indexed view '[RSDB2].[dbo].
[support]' (table or indexed view ID '2105058535', database ID '6'),
full-text key value 0x00000002. Attempt will be made to reindex it.
2007-10-18 11:42:15.13 spid25s The component 'sqlfth90.dll'
reported error while indexing. Component path 'c:\Program Files
\Microsoft SQL Server\90\COM\sqlfth90.dll'.

Reply to this Message

scottoliver06@gmail.com - 18 Oct 2007 21:23 GMT

and here is how I created the db the 1 table and the catalog

create database RSDB2

create table support
(ftid int NOT NULL PRIMARY KEY,
problemId varchar(50) NOT NULL,
problemTitle varchar(50) NOT NULL,
problemBody nvarchar(3850),
lOne varchar(50),
lTwo varchar(50),
lThree varchar(50),
lFour varchar(50))

create fulltext catalog rsCatalog

create unique index ui_support on Rsupport (ftid)

create fulltext index on support (problemBody)
key index ui_support on rsCatalog
with change_tracking auto

insert into support(ftid, problemId, problemTitle, ProblemBody)
values(1,'win1001','testing the database','testing the database for
full text indexing')

select * from support where contains(problemBody, ' "text indexing"
'); ---this search comes back blank

Reply to this Message