How to create full text index by SQL Server Express?

Hi all..

I tried too much to create FULL TEXT INDEX by using SQL Server 2005 Management Studio Express, it returns this ERR MSG:

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

This problem dos not come when I use Microsoft SQL Server 2005 Management Studio, to create FULL TEXT INDEX!

My DB collation is: "Arabic_CI_AS"

But I don’t need this, I can use English Language.

Please, what can I do?

Full Text Indexing is not available in the 'basic' SQL Server 2005 Express.

You must download and install SQL Server 2005 Express Edition with Advanced Services.

Overview

Microsoft SQL Server 2005 Express Edition with Advanced Services (SQL Server Express) is a new, free, easy-to-use version of SQL Server Express that includes a new graphical management tool and powerful features for reporting and advanced text-based searches. SQL Server Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for embedded application clients, light Web applications, and local data stores.

SQL Server Express with Advanced Services has all of the features in SQL Server 2005 Express Edition, plus you can:

Easily manage and administer SQL Server Express with a new easy-to-use graphical management tool -- SQL Server 2005 Management Studio Express (SSMSE).

Issue full-text queries against plain character-based data in SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase.

Run SQL Server Reporting Services reports on local relational data.|||

Of course I'm using sql server with advanced edition, and this problem appears only with it, you may see this URL:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1109200&SiteID=1

In that URL there is no correct answer, so he changed his mind, and as I think, decided to use SQL- Server 2005 Trial instead of (SQL SERVER EXPRESS ADV).

However; as we (me & my friend Ibrahim) understood this ERR message:

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

My friend thought that the correct question is about: how to add languages to support full-text, so he wrote the other question as a correction to this one, not as a repetition.

Thank you very much.

|||

See the follwing links for clarification:

default full-text language Option
"The default value of this option is the language of the server."
http://msdn2.microsoft.com/en-us/library/ms180854.aspx

Setting Server Configuration Options
http://msdn2.microsoft.com/en-us/library/ms189631.aspx

sys.fulltext_languages (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms176076.aspx

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi…

When I execute this query:

select * from sys.fulltext_languages

It returns 0 rows, nothing…

Also when I tried to update sys.fulltext_languages or sys.configurations by using UPDATE or sp_configure it returns this msg:

Ad hoc update to system catalogs is not supported

Also when I tried to enable 'allow updates' it returns same error msg.

Any way, thank you so much…

I will buy SQL Server 2005 Developer edition.

Thank you.

sql