Hi,

I am trying to create an index from a stored procedure. The stored procedure
runs without error, but when I try to use "CONTAINS" or "FREETEXT" on the
table, it tells me that I can't because the table is not indexed.

At the point of this code, a table called 'SearchCompareBase' is already
created and full of data. The syntax I am using to index that table follows.
Can anyone help me get it working:

CREATE INDEX SearchCompareBase_Index
ON SearchCompareBase (Word, Definition, POS, Category)

DECLARE @begin datetime
DECLARE @status int

SET @begin = CURRENT_TIMESTAMP
EXEC sp_fulltext_catalog 'SearchCompareBase_Index', 'start_full'

-- Wait for population to complete
SELECT @status = FullTextCatalogProperty('SearchCompareBase_Index',
'populatestatus')
WHILE (@status <> 0)
BEGIN
WAITFOR DELAY '00:00:01'
SELECT @status = FullTextCatalogProperty('SearchCompareBase_Index',
'populatestatus')
END


Thanks in advance for any help!