|
Home > Archive > SQL Server Full-Text Search > June 2005 > FT indexes are not populating
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
FT indexes are not populating
|
|
| kzakoski 2005-06-28, 1:23 pm |
| 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?
--
Kevin Z
| |
| Hilary Cotter 2005-06-28, 8:24 pm |
| 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/defaul...kb;en-us;317746
--
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
"kzakoski" < kzakoski@discussions
.microsoft.com> wrote in message
news:F1DD2400-556F-4E0A-998A- CF9A2C43F29F@microso
ft.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
> 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?
>
> --
> Kevin Z
| |
| kzakoski 2005-06-28, 8:24 pm |
| Builtin\Administrato
r 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?
--
Kevin Z
"Hilary Cotter" wrote:
> 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/defaul...kb;en-us;317746
>
> --
> 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
> "kzakoski" < kzakoski@discussions
.microsoft.com> wrote in message
> news:F1DD2400-556F-4E0A-998A- CF9A2C43F29F@microso
ft.com...
> sample
>
>
>
| |
| Hilary Cotter 2005-06-28, 8:24 pm |
| 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.
--
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
"kzakoski" < kzakoski@discussions
.microsoft.com> wrote in message
news:1696B0D8-F132-4DAA-9099- 44790BDADB65@microso
ft.com...
> Builtin\Administrato
r 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[color=darkred]
> clause with wildcards I can find it. Any suggestions?
>
> --
> Kevin Z
>
>
> "Hilary Cotter" wrote:
>
the[color=darkred]
|
|
|
|
|