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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Full Text Search

Author  Topic 

yaman
Posting Yak Master

213 Posts

Posted - 2010-07-12 : 14:45:29
Sir ,

I am using full text search on one table .

SELECT * FROM dbo.tbl_Consultant TC
where CONTAIns(tc.FirstName,N'testyaman')

My problem is - when i am insert new record or update exist record in this table then above query unable to fetch new record and update record .

Pls help me out Sir .

Yaman

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-12 : 15:43:01
did u regenerate the catalog?

saw here? http://msdn.microsoft.com/en-us/library/ms142575.aspx
Go to Top of Page

yaman
Posting Yak Master

213 Posts

Posted - 2010-07-12 : 17:46:52
quote:
Originally posted by russell

did u regenerate the catalog?

saw here? http://msdn.microsoft.com/en-us/library/ms142575.aspx



Sir when am regenerate the catalog and track changes automatically

Its find the records but again
add record then again it is unable to find the new record

Yaman
Go to Top of Page
   

- Advertisement -