My fulltext index option in sqlserver2008 is grade out?
is it a seperate install?
A:
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.
u07ch
2009-05-15 16:06:57
+1
A:
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 http://www.microsoft.com/express/sql/download/">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.
Aaron Alton
2009-05-17 02:55:11
A:
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.
Pankaj
2010-01-15 12:35:47