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
Title:
Why not getting any results?
Environment versions
SQL Server:
SQL Server 2000
Application:
Desktop
Miscellaneous
Thread ID:
01365575
Message ID:
01365575
Views:
54
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'
Next
Reply
Map
View

Click here to load this message in the networking platform