My fulltext index option in sqlserver2008 is greyed out? [closed]
Asked Answered
A

7

11

My fulltext index option in sqlserver2008 is greyed out?

Is it a seperate install?

Alysaalyse answered 15/5, 2009 at 15:38 Comment(1)
possible duplicate of Why the Full-Text indexing option is greyed out?Penhall
R
13

You can enable it by executing sp_fulltext_database command.

Romona answered 17/12, 2010 at 8:49 Comment(1)
Thanks Ashish! When migrating older DBs over to 2008 I was unable to work with full-text until setting the property w/ this SPFulgurating
N
9

Make sure the Full Text Search feature was installed. Run the following query against your database:

SELECT SERVERPROPERTY('IsFullTextInstalled')

A result of '0' (Zero) means Full Text search is not installed on the server.

A result of '1' (one) means Full text search is installed on the SQL Server.

If it is not installed you'll need to rerun the SQL Server setup and add the Full Text Search feature. Here's a good article that shows you how to Verify & Install Full Text Search

Neolatin answered 30/5, 2013 at 2:15 Comment(0)
S
6

You need to execute this system sproc to enable fulltext indexing:

--enable fulltext index
EXEC sp_fulltext_database 'enable'
Sauerbraten answered 20/2, 2015 at 6:24 Comment(0)
T
2

You don't mention which edition of SQL Server you're using, but if it's SQL Express, you need to make sure that you've downloaded and installed SQL Server 2008 with Advanced Services. The "plain" SQL Server Express install doesn't include Full-Text Search (to keep the package size to a minimum). View and download the various editions here.

If you're on a non-express version, you need to make sure that you've installed the Full-Text search feature - if you haven't, run the installer again and select "full text search" on the features page.

Troll answered 17/5, 2009 at 2:55 Comment(0)
O
2

I fix the problem by restarting SSMS 18.1

Objection answered 27/6, 2019 at 19:16 Comment(1)
Stupidly enough, this worked for me.Incomplete
A
0

Where are you looking that its greyed out ? If its on a database you need to go to storage / full text catalogs in management studio to change full text settings in sql server 2008.

You can check its installed in the first place by going to services; by default it seems to be disabled after install. If its not installed you can change the installed components through add remove programs.

Annelleannemarie answered 15/5, 2009 at 16:6 Comment(0)
S
0

Try by creating a new database, because I was also having the same problem. I just created a new database and happy to see that Full-text Index enabled.

Stephniestepladder answered 15/1, 2010 at 12:35 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.