Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

full text index after insert?

Status
Not open for further replies.
HomerJS

HomerJS

Programmer
Jun 25, 2001
86
0
0
US
Is there a way to reindex a full text indexed filed after inserting record(s)?

I have a table of customers, with the name having a full text index, and after inserting more records the CONTAINS search does not include the new records.
 
Sort by date Sort by votes
Look up "full-text catalogs" in the BOL index. There is all the info you need there, including how to rebuild the catalogs.

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
136
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
76
grnzbra
grnzbra
Cpreston
  • Locked
  • Question
Update another column if text in another exists 2
Replies
4
Views
60
Cpreston
Cpreston
bmacbmac
  • Locked
  • Question
How to import plain text from Word doc to SQL 1
Replies
4
Views
96
Chris Miller
Chris Miller
ahmedsa19051985
  • Locked
  • Question
After adding Feature Name and Feature Value query takes more than 5 minutes
Replies
4
Views
59
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top