Difference between revisions of "Repair Full Text Search"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
## Delete the catalog | ## Delete the catalog | ||
## When done, should just be one full text search catalogs with the exact same name as the SME database | ## When done, should just be one full text search catalogs with the exact same name as the SME database | ||
| − | ## [[File:FTSfinal.png]] | + | ## [[File:FTSfinal.png]] Note: Your name will be different and match your SME database name. |
# Reindex SME or in SME run tech code 1202 to make the full text indexes rebuild | # Reindex SME or in SME run tech code 1202 to make the full text indexes rebuild | ||
Latest revision as of 15:14, 5 April 2016
If SME advanced search is no longer working due to issues with SQL Full Text Search, follow these instructions to repair SQL full text search:
- In mssql studo, go to: Database>Storage>Full Text Catalogs
- [[File:FullTextCatalog.png
- From the list, attempt to delete all that DON’T match the current db name.
- (Right click, DELETE).
- If you can’t delete it, follow these steps:
- Double click the catalog name:
- Click Tables/Views
- Remove all entries in the right hand box:
- Move from right to left by clicking the left arrow button
- Click ok
- Delete the catalog
- When done, should just be one full text search catalogs with the exact same name as the SME database
Note: Your name will be different and match your SME database name.
- Double click the catalog name:
- Reindex SME or in SME run tech code 1202 to make the full text indexes rebuild
