Is it possible to stop the Full Text Search from searching the Product Description.
Thanks, Typical Monday...
Is it possible to stop the Full Text Search from searching the Product Description.
Thanks, Typical Monday...
Sure. Modify the aspdnsf_GetProducts stored proc and remove (patindex(@searchstr, isnull(p.Description, '')) > 0).
You'll have to take note though, once you'd changed that whether the FTS is turned on or not, you won't be able to search into the product description field. You might want to make a backup first so you can restore it later once needed.
Thats actually not in the aspdnsf_GetProducts sproc, after it gets changed when installing FTS.
It's only located in the aspdnsf_GetProducts_ORIGINAL.
What I did do, was right click the Product table > Full-Text index > Properties.
In the FTS properties I selected the Columns page on the left and then just made sure that
the Name column was the only one selected, of course this is all that I want indexed and thats it.
Almost a whole day, _BrianCruz - v9:no source![]()
Last edited by BCru3; 08-05-2010 at 08:28 AM.