FT indexes are not populating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kzakoski - 28 Jun 2005 19:52 GMT

I've created a couple of full-text indexes using the FT wizards and/or sample
code from BOL. Everything appears to be correct and I've run a full
population on them without getting any errors. However, when I run my
queries to test the results I get no rows returned. When I look at the
properties of the FT Index, the item count states 0.

Did I miss something on setup?

Signature

Kevin Z

Reply to this Message

Hilary Cotter - 28 Jun 2005 20:58 GMT

Are there any messages from MSSCI or MSSEach in the event log?

You also might want to review this kb article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;317746

Signature

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

> I've created a couple of full-text indexes using the FT wizards and/or sample
> code from BOL. Everything appears to be correct and I've run a full
[quoted text clipped - 3 lines]
>
> Did I miss something on setup?

Reply to this Message

kzakoski - 28 Jun 2005 22:09 GMT

Builtin\Administrator account had been removed causing the problem. KB
aritcle had a work around.

Additonal question? Will a FT Index process an entire 'text' datatype
column when building the index or is there a limit on the number of
characters it will process? On the FT index that I just created, I'm
searching the FT columnn that contains SQL scripts. The table name I'm using
in my contains clause is a pretty unique table name, but buried in a lengthy
script. When I run the query, I don't get any matches, but if I use a LIKE
clause with wildcards I can find it. Any suggestions?

Signature

Kevin Z

> Are there any messages from MSSCI or MSSEach in the event log?
>
[quoted text clipped - 10 lines]
> >
> > Did I miss something on setup?

Reply to this Message

Hilary Cotter - 29 Jun 2005 02:38 GMT

From BOL entitled Filtering Supported File Types

Note For full-text indexing, a document must be less than 16 megabytes (MB)
in size and must not contain more than 256 kilobytes (KB) of filtered text.

Signature

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

> Builtin\Administrator account had been removed causing the problem. KB
> aritcle had a work around.
[quoted text clipped - 21 lines]
> > >
> > > Did I miss something on setup?

Reply to this Message