Menu
I have instaled SQL server 2008 R2 and when I run this SQL in SQL server management studio:
SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')
I get 0
But If I run this:
SELECT * FROM sys.fulltext_catalogs
I get one row. I want to know If fulltext search is installed on my sql server or do I need to reinstall SQL server with advance options.
Please suggest.
967
Look at the list of services on the machine. If full text search is installed you'll see a service named SQL Server FullText Search ([instance]) where [instance] will be the name of the SQL instance that it is associated with.
Full-text search is meant to search large amounts of text. For example, a search engine will use a full-text search to look for keywords in all the web pages that it indexed. The key to this technique is indexing.
Select 'Add features to an exisiting instance of SQL Server 2019' and use SENT4EXPRESS as the instance. Click [Next]. Under 'Instance Features', select 'Full-Text and Semantic Extractions for Search'.
My answer:
If FULLTEXTSERVICEPROPERTY says it's not installed, then I would install from the original media. Run through the installer and simply add Full Text Search from the features page.
FTS is fully in the SQL Engine in 2008 so if it thinks it isn't installed, then ya best make it happy.
My opinions/ponderings:
Did you move a database from a previous SQL installation that had full text installed? That might explain the row in sys.fulltext_catalogs.
When you open a Database in SSMS, under the Storage Folder, Full Text Catalog folder do you have the option to add a New Catalog when you right click?
In SQL Configuration Manager do you see the Full Text Daemon Launcher service?
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
