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