 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / May 2006How do I know the catalog is working and the indexing is finished populated
I just created a catalog in pubs includes table 'emplyee'. How do I know the indexing population is finshed? Run the following query: SELECT FULLTEXTCATALOGPROPERTY(@CatalogName, 'PopulateStatus'), OBJECTPROPERTYEX(OBJECT_ID(@TableName), 'TableFulltextPopulateStatus') If it returns 0, the indexing population is finished. Otherwise, it should return one of the following values indicating the respective status: 0 = Idle 1 = Full population in progress 2 = Paused 3 = Throttled 4 = Recovering 5 = Shutdown 6 = Incremental population in progress 7 = Building index 8 = Disk is full. Paused. 9 = Change tracking More details at http://msdn2.microsoft.com/en-US/ms190370.aspx http://msdn2.microsoft.com/en-us/ms188390(SQL.90).aspx check the gatherer logs or the event log for messages from MSSearch or MSSCI. Also check the following properties SELECT fulltextcatalogproperty('test', 'ItemCount') SELECT fulltextcatalogproperty('test', 'uniquekeycount') where test is the name of your catalog.  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 > Run the following query: > [quoted text clipped - 18 lines] > http://msdn2.microsoft.com/en-US/ms190370.aspx > http://msdn2.microsoft.com/en-us/ms188390(SQL.90).aspx Hi Hilary, It returns the ItemCount is 0 and uniquekeycount is 1. So what does it tell? > check the gatherer logs or the event log for messages from MSSearch or > MSSCI. Also check the following properties [quoted text clipped - 40 lines] > > http://msdn2.microsoft.com/en-US/ms190370.aspx > > http://msdn2.microsoft.com/en-us/ms188390(SQL.90).aspx How many rows are in the table you are indexing? The itemcount should be numer of rows + 1 for sql 2000 or number of rows for sql 2005. I expect you have not populated the index on the table yet, that is why you only have an itemcount of 1. If you created a non-changetracking index you need to start the population using: exec sp_fulltext_table '<table name>, 'start_full' if you are using sql 2005 you can do the same thing with the following statement: alter fulltext index on <tablename> start full population SignatureDave Poole SQL Server Fulltext Team This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. > Hi Hilary, > [quoted text clipped - 45 lines] >> > http://msdn2.microsoft.com/en-US/ms190370.aspx >> > http://msdn2.microsoft.com/en-us/ms188390(SQL.90).aspx Hi, I checked that both output columns are 0 and 0. Any idea why they are idle ? > Run the following query: > [quoted text clipped - 18 lines] > http://msdn2.microsoft.com/en-US/ms190370.aspx > http://msdn2.microsoft.com/en-us/ms188390(SQL.90).aspx |
Reply to this Message |
 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.