Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why not getting any results?
Message
General information
Forum:
Microsoft SQL Server
Category:
Full text indexing
Environment versions
SQL Server:
SQL Server 2000
Application:
Desktop
Miscellaneous
Thread ID:
01365575
Message ID:
01365664
Views:
10
Do you get any results for regular queries?
select * from masterFL where descr LIKE '%green%'
select * from masterFL where note LIKE '%green%'
>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'
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform