Re: FT index doesn't auto populate

Hi Hilary

Thanks for the quick response. You suggested there are differences in
behaviour between RTM and SP1. I'm using version 9.00.1399.06. I don't
believe I've installed SP1 yet, but, I will make sure I have SP1 installed so
we're all on the same version. Regardless, can you rephrase and elaborate on
your answer? I'm not sure I understand what you are suggesting I do.

You suggest three things;
1) You say to use change tracking. That is one of the scenerio's I tried
and it didn't seem to help. In 2005 we seem to have three options for Change
tracking -- Auto, Manual, and None. I've tried all three. The documentation
says Auto should provide near realtime updates to the index
2) You say to "enable the fulltext index". I do not see an option for that.
I see how I need to enable full text indexing for the database before
creating a FT index. That has been done already
3) You say to kick off the full index population. Not sure what you mean.
The full population kicks off automatically when you first create the index
(with Auto selected). Also, I've tried to manually perform a Full population
index. That doesn't help

One more thing, the wizard is not able to create it's catalog maintenance
job at the end of the wizard steps. The job gets created but I get an error
40 creating the job step that says Named Pipes cannot connect to the server.
It suggests I may not have remote access turned on. However, I have Named
Pipes and TCP access turned on, and, in fact can connect to the database just
fine with the application software using OLEDB. That doesn't seem to be the
problem. Any suggestions on this? Can the two problems be related? This is
a very vanilla installation of SQL on Windows 2003. I haven't changed
anything yet.

--
Maz


"Hilary Cotter" wrote:

Use change tracking. In SQL 2005 SP 1 a population is not automatically set
off after you create your full-text index the way it would occur in RTM. You
need to enable the fulltext index, and you may need to start the full
population. Then change tracking should kick in.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Spicy Mikey" <Maz@xxxxxxxxxxxxxxxxx> wrote in message
news:7C90F276-A695-4D0D-9DA4-1FD6E7792A22@xxxxxxxxxxxxxxxx
Sorry, I think there's some more info I should mention so no one goes down
the wrong road;

1) I'm using SQl 2005 Standard Edition

2) I've checked teh Crawl Logs and they show nothing around the time I
make
the changes. I do see an entry when I do a Full index build. It shows
19000
records indexed with 0 errors.

3) The index seems to be updated when I change the row the first time,
however, if I try to change it again (and put the keyword in the row
again)
the index doesn't seem to be updated. This means, that row displays with
the
changed word, but, it's ranking still reflects the row before the change.
i.e. the index didn't get updated.

4) The query I'm executing to do the search and rank is as follows;

USE AdventureWorks
GO
SELECT top 100 AddressLine1, KEY_TBL.RANK
FROM Person.Address AS Address INNER JOIN
CONTAINSTABLE(Person.Address, AddressLine1, 'ISABOUT ("Bay*",
Street WEIGHT(0.9),
View WEIGHT(0.1)
) ' ) AS KEY_TBL
ON Address.AddressID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK desc
GO


--
Maz


"Spicy Mikey" wrote:

I have to start by saying I'm new to FTS in SQL Server and could be doing
something stupid. However, everything I've read so far contradicts what
I'm
seeing. Here's the issue;

I setup an FTS index in the Adventureworks DB using the Address1 field in
the Address table to query against some sample code I found. I've set up
this index every possible way (auto track, manual track, etc.), but I
cannot
get this index to repopulate in realtime consistantly. In other words,
if I
go into the table and change a row in the Address table, the index does
not
change most of the time. I've seen it change sometimes but I can't find
a
pattern for why that happens.

I've used SSMS exclusively to enable FTS on the database and table as
well
as defining the index itself. After the change is made to the tables
data,
I run the query to search for matches and the results do not reflect the
change I just made. I tried to "force" it by using the SMSS menus and
doing
a "Start Incremental Population", nothing happens. I've tried doing a
Start
Full Population", and nothing happens UNLESS I have previously set the
"Track
Changes" option to OFF during setup. In this one situation I can
manually
force the index to rebuild by having Track Changes Automatically turned
off
and then executing a "Start Full Population". Of course, this is not a
solution. I need this index to stay current on its own.

What am I doing wrong? Am I missing something fundamental? Is there
some
good reading someone can point me to?



--
Maz



.