How to install FullText Search on SQL Server 2008 [duplicate]
Possible Duplicate:
How to install fulltext on sql server 2008?
I have recently installed SQL Server 2008 R2
When I tried to create Full Text Search Index
Example
CREATE FULLTEXT INDEX ON DATABASENAME.dbo.MYTABLE
(
column_to_index
Language 0X0
)
KEY INDEX myindex ON DATABASENAMECatalog
WITH CHANGE_TRACKING AUTO
It had given me following error:
Msg 7609, Level 17, State 5, Line 4 Full-Text Search is not installed, or a full-text component cannot be loaded.
I tried following
1: Right Click on My Computer and Click "Manage"
2: Double Click "Services and Applications"
3: Double Click "SQL Server Configuration 开发者_如何转开发Manager"
But I can't able to perform following 2 steps, as their is No FULL TEXT SEARCH service was their.
4: Double Click "SQL Server Services"
5: Check if "SQL Server Full Text Search" is not started, than Right Click and Press on Start.
Can anyone please guide me how to install full text search on SQL Server 2008
The simplest way to validate whether or not you have installed the Full Text "component" of SQL Server 2008 is to execute the following T-SQL
select SERVERPROPERTY('IsFullTextInstalled')
If this query returns a value of '1' then the component is installed.
For further readining on how to get started see: Getting Started with Full-Text Search
As the comments suggested, you should probably re-install and make sure you choose the Full-Text Search option (directly under SQL Server Replication).
(source: free.fr)
FYI, this image comes from a step by step install guide
精彩评论