Status of full text indexing

Does anyone know how to determine the status of the full text indexing; i.e. how far along in the process it is.

I can see by Select FULLTEXTCATALOGPROPERTY('myCatalog', 'PopulateStatus') that the catalog is being populated, but the values for itemCount and uniqueKeyCount are 0. I don't know how to interpret these as a percent complete, but I could compare them to my test system.

Any suggestions would be appreciated

Thanks

marc

 

OK, it looks like you can get the number of rows processed using:

SELECT OBJECTPROPERTYEX(OBJECT_ID(N'<table>'), N'TableFulltextItemCount') as RowsIndexed ;

This works quite well in my test environment, but returns 0 on the DASP SQL Server.

Does anyone have any idea why not?


Thanks

marc

 

Do you just need help with SQL?
Have you gotten used to Books on-line by the way?
BOL is the SQL Developers friend.
Salute,
Mark

 

Actually, what I am looking for is why the system procedures listed in the earlier posts don't work on DASP.

marc

 

If it's returning null I'd suspect the database, schema or object context.

For example, the database path should look like this:
SELECT OBJECTPROPERTYEX(OBJECT_ID(N'DASPDB.Table.vRecord') as RowsIndexed);

That transact SQLreturns schema-scoped objectsfrom the current database.

 

As noted above, the return value is 0, not null