tag:blogger.com,1999:blog-78215147778428853892024-09-13T08:09:47.271-07:00Anonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7821514777842885389.post-77835928588931760392012-05-10T12:02:00.004-07:002012-06-18T07:26:41.198-07:00<span style="color: blue;">Issue: </span><br /> 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. <br /> <br /> <span style="color: blue;">Solution: </span><br /> •&nbsp;&nbsp;&nbsp; Make sure that all the services, SQL server service, Agent service and FULL Text service are running under same account. <br /> •&nbsp;&nbsp;&nbsp; if you have already created the FT Catalog then rebuild it<br /> •&nbsp;&nbsp;&nbsp; exec sp_fulltext_service 'restart_all_fdhosts'<br /> <br /> <br /> ---------------------------<b><span style="color: #274e13;">This should solve the issue. If not the do this as well </span></b>------------------------------<br /> <br /> <br /> exec sp_grantlogin N'waterfrontmedia\dbadmin'<br /> exec sp_defaultdb N'waterfrontmedia\dbadmin', N'master'<br /> exec sp_defaultlanguage N'waterfrontmedia\dbadmin','us_english'<br /> exec sp_addsrvrolemember N'Waterfrontmedia\dbadmin', sysadminAnonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.com0