all groups > sql server full text search > july 2006 >
You're in the

sql server full text search

group:

Adding a column question


Adding a column question ajay.kalyan NO[at]SPAM gmail.com
7/30/2006 7:39:24 PM
sql server full text search:
I had a fulltext index catalog created on a table with 1 column being
indexed. I needed to add another column from the same table, so I
added the new column to the catalog and restarted a full population
again.

I tried testing the new catalog, but the new column doesnt seem to be
indexed. How can I tell if the new column is actually indexed. I used
sp_fulltext_column with the add action. The documentation on msdn says
that it adds the column to table's inactive fulltext index. Do I need
to reactivate the table anf then do a full population?

Thanks in advance
Re: Adding a column question Hilary Cotter
7/31/2006 12:00:00 AM
Its not clear to me from your post - have you done a full-population? You
will need to do one.

--
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]

Re: Adding a column question ajay.kalyan NO[at]SPAM gmail.com
7/31/2006 10:06:54 AM
I did a full population. I have 2 questions.

1. Do I need to reactivate the table and then do a full population.
2. How do I check whether a specific column has been full text indexed.

Thanks
Re: Adding a column question Hilary Cotter
7/31/2006 2:15:35 PM
1) I didn't have to
2) you can't other than by searching for test phrases which you know are in
the column. When your population status reads idle you know you are
complete.

--
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]

AddThis Social Bookmark Button