开发者

How to install FullText Search on SQL Server 2008 [duplicate]

开发者 https://www.devze.com 2023-01-05 11:09 出处:网络
This question already has answers here: Closed 12 years ago. Possible Duplicate: How to install fulltext on sql server 2008?
This question already has answers here: Closed 12 years ago.

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).

How to install FullText Search on SQL Server 2008 [duplicate]


(source: free.fr)

FYI, this image comes from a step by step install guide

0

精彩评论

暂无评论...
验证码 换一张
取 消