SQL Server 2005 with advanced services and full text search

SQL Server 2005 with advanced services and full text search

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.

date: Thu, 18 Oct 2007 05:26:59 -0700 author: unknown

Re: SQL Server 2005 with advanced services and full text search

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?
 wrote in message 
news:1192710419.432872.278480@v23g2000prn.googlegroups.com...
>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.
>

date: Thu, 18 Oct 2007 11:50:23 -0400 author: Hilary Cotter

Re: SQL Server 2005 with advanced services and full text search

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'.

date: Thu, 18 Oct 2007 11:02:54 -0700 author: unknown

Re: SQL Server 2005 with advanced services and full text search

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

date: Thu, 18 Oct 2007 13:23:47 -0700 author: unknown