Thursday, May 10, 2012

Full Text index is not working – SQL 2008 R2

Issue:
I have created a full text index for a table, populated it and then at the property I see that there is 0 item count. My full text index is not working.

Solution:
•    Make sure that all the services, SQL server service, Agent service and FULL Text service are running under same account.
•    if you have already created the FT Catalog then rebuild it
•    exec sp_fulltext_service 'restart_all_fdhosts'


---------------------------This should solve the issue. If not the do this as well ------------------------------


exec sp_grantlogin N'waterfrontmedia\dbadmin'
exec sp_defaultdb N'waterfrontmedia\dbadmin', N'master'
exec sp_defaultlanguage N'waterfrontmedia\dbadmin','us_english'
exec sp_addsrvrolemember N'Waterfrontmedia\dbadmin', sysadmin

No comments:

Post a Comment