CODEWITHSUNDEEP
sql-serversql-server-2005full-text-search
Charles
Charles

Reputation: 65

How to turn on the FULLTEXT mode on SQL Server 2005

I'm currently trying to create FULLTEXT indexes into my database (Microsoft SQL Server 2005).

First I want to create the catalog:

USE [AspDotNetStorefront]
GO
EXEC sp_fulltext_database 'enable'
GO
CREATE FULLTEXT CATALOG searchcatalog 
GO

But that doesn't work, the result is this:

Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.

I'm running on Windows XP, SQL Server Express 9.0.4053 and I have SQL Server Management Studio Express (9.0).

Upvotes: 0

Views: 1927

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294287

Full-Text search is only available in the SQL Express Advanced versions, see Features Supported by the Editions of SQL Server. Get 2005 from Microsoft SQL Server 2005 Express Edition with Advanced Services, 2008 from Microsoft SQL Server 2008 Express with Advanced Services

Upvotes: 2

Related Questions