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.
| Author |
Topic |
|
Mladen
Starting Member
6 Posts |
 Posted - 2008-07-23 : 08:42:52
|
| I've got FTS working on all three SQL instances on my computer with SQL 2000, SQL 2005 and SQL 2008. However on another computer there is an error:The component 'sqlfth90.dll' reported error while indexing. Component path 'c:\Program Files\Microsoft SQL Server\90\COM\sqlfth90.dll'.2008-07-22 11:53:18.21 spid18s Error '0x80040e14' occurred during full-text index population for table or indexed view 'FTS is installed. Rebooting or rebuilding with ALTER FULLTEXT CATALOG REBUILD did not help. The database is not corrupt since if dumped from the server where FTS does not work and restored on mine with ALTER FULLTEXT CATALOG REBUILD it works. I found something that could be related ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/964c43a8-5019-4179-82aa-63cd0ef592ef.htm This failure can occur if the table row contains a document format or content in a language that has not been registered with the instance of SQL Server 2005What exactly does " language that has not been registered with the instance of SQL Server 2005" mean ? Any other suggestions? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-23 : 23:11:28
|
| Did you check app event log for related errors? Do you store text in different languages in the table? |
 |
|
|
Mladen
Starting Member
6 Posts |
Posted - 2008-07-24 : 09:28:28
|
| Thanks for your answer. Yes, I had already checked the app event log - nothing there. No, it is only in English. But even if it were in any other additional language, it stil workes when restored on my server. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-24 : 11:20:45
|
| any weird non english chars in your texts?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
Mladen
Starting Member
6 Posts |
Posted - 2008-07-28 : 07:07:41
|
| Hi namesake, no weird non English chars , but even if there were , as I said in my previous post, the restored database works on my servers. |
|
|
|
|
|
|
Full Text Search population problem