FREETEXT Document Title search -- sql server full text search

Jeremy
8/19/2004 10:09:57 AM

Is there a way using full text search to search on the title of a document
(i.e. The title used by Microsoft Word in it's title field, not the actual
name of the file)? I have stored procedures using FreeTextTable, but this
doesn't seem to be returning results based on the titles. Is this the
expected behavior? Is there a way around this? Thanks in advance!

Hilary Cotter
8/19/2004 10:46:00 AM

No, there is no way to do this natively as SQL FTS does not index the
properties of documents only its contents. You would have to extract the
Document Title and store it in another column in the table.

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

[quoted text, click to view]

sql server full text search : FREETEXT Document Title search