Wednesday, March 7, 2012

new index, catalog empty

I have created a FT Index on a varchar(200) col of my 'movies' table.
The table has about 2000 rows, so there is lots to index.
But even after forcing a catalog rebuild and full population, the catalog
remains empty.
(item count 0, unique key count 1, etc..)
Any ideas ?
Any error messages in the event log from MSSearch or MSSCI?
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
"Tony B." <Test@.spam.ca> wrote in message
news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>I have created a FT Index on a varchar(200) col of my 'movies' table.
> The table has about 2000 rows, so there is lots to index.
> But even after forcing a catalog rebuild and full population, the catalog
> remains empty.
> (item count 0, unique key count 1, etc..)
> Any ideas ?
>
>
|||sql server general "ERRORLOG" (all caps, no file extension)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Any error messages in the event log from MSSearch or MSSCI?
> --
> 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
>
> "Tony B." <Test@.spam.ca> wrote in message
> news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||I assume you are telling me the contents of the log directory. I want you to
look in the application log. At a command prompt type eventvwr, hit enter,
and drill down on application log. Look for messages from mssci, or mssearch
and post them back here.
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
"Tony B." <Test@.spam.ca> wrote in message
news:%23aOiEMnDHHA.3212@.TK2MSFTNGP04.phx.gbl...
> sql server general "ERRORLOG" (all caps, no file extension)
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
>

No comments:

Post a Comment