 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / July 2006Adding a column question
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 Its not clear to me from your post - have you done a full-population? You will need to do one.  SignatureHilary 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 >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 [quoted text clipped - 8 lines] > > Thanks in advance 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 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. SignatureHilary 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 >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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.