Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why not getting any results?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation intégral de texte
Titre:
Why not getting any results?
Versions des environnements
SQL Server:
SQL Server 2000
Application:
Desktop
Divers
Thread ID:
01365575
Message ID:
01365575
Vues:
55
I'm running the following lines and getting no errors. But also not getting any results what am I doing wrong?
--create a catalog
EXEC sp_fulltext_catalog 'ims', 'create'

--create table / PK
EXEC sp_fulltext_table 'masterFL', 'create', 'ims', 'pk_MasterFL'

--Add some columns
EXEC sp_fulltext_column 'masterFL','Descr','add'
EXEC sp_fulltext_column 'masterFL','note','add'

--Activate and populate the index
EXEC sp_fulltext_table 'masterFL', 'activate'
EXEC sp_fulltext_table 'masterFL', 'start_full'

--activate and propagate  
EXEC sp_fulltext_catalog 'ims', 'start_full'

-- test it...
select * from masterFL where contains(descr, 'green')
select * from masterFL where contains(note, 'green')

--To remove a full-text index
--EXEC sp_fulltext_table 'ims', 'drop'
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform