Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 900
Jordon Willis Avatar asked Jul 04 '10 01:07

Jordon Willis


1 Answers

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

like image 86
John Sansom Avatar answered Oct 12 '22 01:10

John Sansom