Last post Jan 16, 2008 09:40 AM by jkorkiner
Jan 16, 2008 09:40 AM|jkorkiner|LINK
My current store proc looks like this ...
ALTER PROCEDURE [dbo].[Search]
-- Add the parameters for the stored procedure here
SELECT Q.Rank, Title, ArticleID, REPLACE(SUBSTRING(Article,0,250), '<br />', ' ')AS Article
FREETEXTTABLE(Articles, *, @q) Q
ORDER BY Rank DESC;
However Rank always returns as 0, unless I run ALTER FULLTEXT CATALOG catalog_name REBUILD first. Then it will Rank correctly for a certain amount of time/usage, then report back as 0 again. I am willing to run the rebuild command every time if needed, just
don't know where to add the alter command to the store proc. Thanks!