Groups | Blog | Home
all groups > sql server full text search > may 2006 >

sql server full text search : NT Authority\System


Hilary Cotter
5/30/2006 10:05:16 PM
This should work, can you issue the following sp_fulltext_table
'employee','start_full' and then retry?

If it doesn't work check the gatherer logs.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Alan
5/31/2006 12:00:00 AM
I cannot get the catalog running and read the knowledge base :

ArticleID -317746
http://support.microsoft.com/kb/317746/en-us

So I issued the command said in the article against the master db in QA.
Then tested with

select fname, lname
from employee
where contains (fname, 'Gary')

However, the result returned was empty with column headers only.

AddThis Social Bookmark Button