Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

fulltext search sql2000

Status
Not open for further replies.

fedum

Technical User
Mar 22, 2004
104
0
0
BE
Hi,
I have updated my pc to a Windows Server 2008 and sql 2000 (before Win Server 2000 and sql 7). I use the fulltext search with a catalog HendrikxCatalog. With this latest configuration the fulltext search gives me no result anymore. I have made the catalog in the sql manager used the table artikel and used the population. There wasn't any problem. The catalog is idle.

I allso just the instructions in the queryanalyser
use Hendrikx
go
execute sp_fulltext_table 'artikel','drop'
execute sp_fulltext_catalog 'HendrikxCatalog','drop'
execute sp_fulltext_database 'enable'
execute sp_fulltext_catalog 'HendrikxCatalog','create'
execute sp_fulltext_table 'artikel','create','HendrikxCatalog','PK_artikel_id'
execute sp_fulltext_column 'artikel','omschrijving','add'
execute sp_fulltext_column 'artikel','uitleg','add'
execute sp_fulltext_table 'artikel','activate'
execute sp_fulltext_catalog 'HendrikxCatalog','start_full'

Allso no errors.

PLease advise.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top