sql server full text search: Add Category to SQL Full-text -- sql server full text search

Add Category to SQL Full-text

derekvof NO[at]SPAM yahoo.com
3/23/2004 1:10:44 PM

sql server full text search: I'm moving my STS sites to WSS, and I'm running into a bit of a
problem. We've got everyone on our team adding a category to their
documents to help us search and organize them. However, seach under
WSS (w/ SQL and Free-Text search) doesn't pick up the category field
in my Word documents.

I saw some talk about adding it via SQL so it appears in searchs
through Sharepoint, but I've no idea how. Any suggestions or

Re: Add Category to SQL Full-text

Hilary Cotter
3/23/2004 5:30:20 PM

that's correct. SQL FTS only indexes documents contents when they are stored
in the image data type columns. It doesn't index properties. You would have
to extract the property and store it separately in a column in the table you
are full text indexing.
[quoted text, click to view]