Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lightmar
Starting Member
3 Posts |
 Posted - 2008-08-29 : 03:50:03
|
| Hi,I have a table with an index. I am trying to run a query to rebuild the index, but not matter what query I run, the search option in my website don't find the new data in the table.I tried to use: DBCC DBREINDEX, I tried: ALTER INDEX ALL ON __ REBUILDI tried:CREATE CLUSTERED INDEX __ ON __ WITH(DROP_EXISTING = ON)All of these queries do executes, but still, I don't see that the search option in my website returns the new data in the table.Thanks for any help.http://www.gienga.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-29 : 03:55:23
|
| Rebuilding an index doesn't make data appear or disappear. If data isn't appearing in your application, then you've got a coding issue or lack of data in the database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
lightmar
Starting Member
3 Posts |
Posted - 2008-08-29 : 05:29:31
|
| Yes, but freetext search on a table is depended on the table index, isn't it? The search option in my website only returns the data that was indexed when I created the index. Now I have added data to the table and I would like to index it.Rebuilding the index is the way to do it, isn't it?http://www.gienga.com |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-29 : 06:35:48
|
| Did you mean Fulltext? |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-29 : 06:38:33
|
| If so, see: http://arcanecode.wordpress.com/2007/06/27/getting-started-with-sql-server-2005-full-text-searching-part-2-%E2%80%93-the-indexes/ |
|
|
|
lightmar
Starting Member
3 Posts |
Posted - 2008-08-29 : 15:57:55
|
| Yes! That worked.Thanks!http://www.gienga.com |
|
|
|
|
|
|
Rebulid Index Not Working