Enable a Table for Full-Text Indexing

Hi,

I am using SQL SERVER 2005 Express. I am trying to set up Enable a Table for Full-Text Indexing. I am following these instructions:

How to: Enable a Table for Full-Text Indexing (SQL Server Management Studio)

Updated:1 February 2007

In SQL Server 2005, by default, all user-created databases are full-text enabled. Additionally, an individual table is automatically enabled for full-text indexing as soon as a full-text index is created on it and a column is added to the index. A table is automatically disabled for full-text indexing when the last column is dropped from its full-text index.

You can manually disable or reenable a table for full-text indexing by using SQL Server Management Studio.

var ExpCollDivStr = ExpCollDivStr;ExpCollDivStr = ExpCollDivStr + "ctl00_LibFrame_ctl06e22b87c,";var ExpCollImgStr = ExpCollImgStr; ExpCollImgStr = ExpCollImgStr + "ctl00_LibFrame_ctl06img,";To enable a table for full-text indexing

Expand the server group, expandDatabases, expandUser Databases, and expand the database that contains the table you want to enable for full-text indexing.

Right-click the table that you want to enable for full-text indexing.

SelectFull-Text index, and then clickEnable Full-Text indexing.

From: http://technet.microsoft.com/en-us/library/ms142536.aspx

However this selection "SelectFull-Text index, and then clickEnable Full-Text indexing"doesnt appear.

I have confirm that the Fulltext is installed with:

SELECT

fulltextserviceproperty('IsFulltextInstalled')

Any help would be great thanks!

Ok, I got it working using:

EXECsp_fulltext_database'enable'

So no I need to create an Full Text index:

CREATE FULLTEXTINDEX ON E190MELCDL(xmldata)KEY INDEX PK_E190MELCDL

But I get this error:

Informational: No full-text supported languages found.

Informational: No full-text supported languages found.

Msg 7680, Level 16, State 1, Line 1

Default full-text index language is not a language supported by full-text search.

Any Ideas?

|||

Here is the full solution. This is a great tutorial if are using SQL SERVER 2005 EXPRESS

http://www.developer.com/db/article.php/629111

Bones