CREATE FULLTEXT INDEX - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

CREATE FULLTEXT INDEX

Author

Topic

bonekrusher
Starting Member

44 Posts

Posted - 2007-09-01 : 13:48:13

Hi All,

I am using SQL SERVER 2005 Express. I am trying to set up CREATE FULLTEXT INDEX.

I have confirmed that the Fulltext is installed with:

SELECT
fulltextserviceproperty('IsFulltextInstalled')

So no I need to create a Full Text index:

CREATE FULLTEXT INDEX
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?

Thanks,

Bones

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-01 : 14:25:18

your sql server and full text service have to both run under the same logon name.
like 'Local System'
you can check in services under which logon each service runs.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

bonekrusher
Starting Member

44 Posts

Posted - 2007-09-01 : 15:42:21

Cool Thanks. Did the trick

bonekrusher
Starting Member

44 Posts

Posted - 2007-09-01 : 17:09:34

Hi I have another question.

When the servers where logged in where "nt authority/networksystems" it did not work. However when I used "Local Systems" it allowed me to create the index, but when I queryed it it returned no data.

I am very confused.

Thanks for the help.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-01 : 18:53:07

Did you populate the catalog yet?

bonekrusher
Starting Member

44 Posts

Posted - 2007-09-01 : 20:25:54

oops no. How do I?

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-01 : 21:48:24

Right click on the catalog in ssms and choose properties -> population schedule, you can set population ther. Can also set auto trace table changes in catalog properties.

bonekrusher
Starting Member

44 Posts

Posted - 2007-09-02 : 07:20:37

Thank you rmiao,

However I think that SQL SERVER 2005 EXPRESS doesnt give me this option. So I had to do it manually. I found this:

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

What a great tutorial.

Thanks again,
Bones

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources