Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / November 2006

Tip: Looking for answers? Try searching our database.

new index, catalog empty

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tony B. - 21 Nov 2006 16:47 GMT
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 ?
Hilary Cotter - 22 Nov 2006 14:07 GMT
Any error messages in the event log from MSSearch or MSSCI?

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 have created a FT Index on a varchar(200) col of my 'movies' table.
>
[quoted text clipped - 5 lines]
>
> Any ideas ?
Tony B. - 22 Nov 2006 20:16 GMT
sql server general "ERRORLOG" (all caps, no file extension)

> Any error messages in the event log from MSSearch or MSSCI?
>
[quoted text clipped - 7 lines]
>>
>> Any ideas ?
Hilary Cotter - 24 Nov 2006 13:23 GMT
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.
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

> sql server general "ERRORLOG" (all caps, no file extension)
>
[quoted text clipped - 9 lines]
>>>
>>> Any ideas ?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.