But i can't find the solution to my issue in the link you reffered. The link explains the procedure of using full text search functionality.
My issue is that i can't find the context menu of the Full Text Catalogs, where there is the New Full-Text Catalog... command in my sql server management studio.
chandan777
Member
189 Points
256 Posts
Can't find full text search option in Sql Server Management Studio
Feb 19, 2013 04:10 AM|LINK
Experts!
I can't find full text search option in my production server .
Can anybody tell me how to enable the fulltextsearch option in the server?
Please Help!
eralper
Contributor
6048 Points
971 Posts
Re: Can't find full text search option in Sql Server Management Studio
Feb 19, 2013 06:08 AM|LINK
Is Fulltext installed on the instance?
Please run following SELECT to check if fulltext feature is installed
SELECT FullTextServiceProperty('IsFullTextInstalled')SQL Server 2012
chandan777
Member
189 Points
256 Posts
Re: Can't find full text search option in Sql Server Management Studio
Feb 19, 2013 06:52 AM|LINK
the query is returning 1, i guess it is installed then.
eralper
Contributor
6048 Points
971 Posts
Re: Can't find full text search option in Sql Server Management Studio
Feb 19, 2013 07:16 AM|LINK
Hi Chandan,
Yes fulltext search feature is installed on your SQL Server instance.
You can also check if fulltext service is already running on the server. Go to Services management console for that.
Please refer to tutorial at http://www.kodyaz.com/articles/SQL-Server-Full-Text-Search-Indexing.aspx as a starting point.
SQL Server 2012
chandan777
Member
189 Points
256 Posts
Re: Can't find full text search option in Sql Server Management Studio
Feb 19, 2013 08:36 AM|LINK
Thanks for your reply.
But i can't find the solution to my issue in the link you reffered. The link explains the procedure of using full text search functionality.
My issue is that i can't find the context menu of the Full Text Catalogs, where there is the New Full-Text Catalog... command in my sql server management studio.
chandan777
Member
189 Points
256 Posts
Re: Can't find full text search option in Sql Server Management Studio
Feb 19, 2013 09:09 AM|LINK
One more point i found is that, i can't see MSSQLFDLauncher in sql server services.
Does it mean that full text search is not installed?
chandan777
Member
189 Points
256 Posts
Re: Can't find full text search option in Sql Server Management Studio
Mar 08, 2013 06:24 PM|LINK
I reinstalled the software and it resolved the issue