FREETEXT Document Title search

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!
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
"Jeremy" <jmaddreysp@.cox.net> wrote in message
news:OvcQ2YfhEHA.2540@.TK2MSFTNGP10.phx.gbl...
> 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!
>
>