-
Open the Registry Editor, by:
- Clicking Start, and clicking Run.
- In the Run dialog box, in the Open box, type Regedit.
- In Registry Editor, select the following registry key for the first instance of SQL Server: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSearch\CLSID (Please replace the MSSQLSERVER with the real instance name if it's named instance)
- On the menu bar, click Edit, click New, and click Key.
- Type {9DAA54E8-CD95-4107-8E7F-BA3F24732D95}.
- Press ENTER.
- In the right pane, right-click the Default registry value, and then click Modify.
-
In the Edit String dialog box, in the Value data box, type NaturalLanguage6.dll, and then click OK.
- In Registry Editor, select the following registry key for the first instance of SQL Server:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSearch\Language\enu
-
Replace the 'WbreakerClass' and 'StemmerClass'with new value as below
WBreakerClass:{9DAA54E8-CD95-4107-8E7F-BA3F24732D95}
StemmerClass :{61A48126-EF74-4d4a-9DDA-43FD542CAD1E}
-
Copy files:
from "C:\Windows\System32"
to "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn"
NlsData0009.dll
NlsLexicons0009.dll
Now , we are going to create our own customized word breaker
- Log on to sql server box under window administrator account
- Open a notepad
-
Put below words following the rule list in article http://technet.microsoft.com/en-us/library/cc263242.aspx#Rules
red/bl
-st/fl
red/
24-
- On the File menu, click Save As.
- In the Save as type list, select All Files.
- In the Encoding list, select Unicode.
- In the File name box, type the file name in the following format: Custom0009.lex, (Please do not change the file name)
- put the file to the sql server instance binn folder , for example : C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn.
- Restart fdhost by executing "exec sp_fulltext_service 'restart_all_fdhosts'" on the sql server instance.
- Now the customized word breaker works, here is a screenshot of test:
Please note, before we configure the word break , the result is as below
select *From sys.dm_fts_parser('red/bl',1033,0,0)
customized English word breaker for sql server 2008
相關文章
- SQL Server 2005 Developer Edition English Version Setup on Windows 7SQLServerDeveloperWindows
- SQL Server 2008中Analysis Services的新特性——深入SQL Server 2008SQLServer
- SQL SERVER 2008安全配置SQLServer
- SQL Server 2008 過期SQLServer
- 安裝sql server 2008SQLServer
- SQL Server 2008 安全更改SQLServer
- 微軟之日 --- SQL Server 2008微軟SQLServer
- 練習英文寫作 Learn to write the english word
- 怎樣從SQL Server2008升級到SQL Server 2008 r2SQLServer
- SQL Server 2008快照備份SQLServer
- SQL Server 2008 優化工具SQLServer優化
- SQL Server 2008備份概述SQLServer
- sql server 2008 是否值得期待?SQLServer
- SQL Server 2008密碼策略SQLServer密碼
- SQL Server 2008 sqlcmd 的使用SQLServer
- SQL Server2008引擎元件SQLServer元件
- Installing SQL Server 2008 on a Windows Server 2008 ClusterSQLServerWindows
- Inside SQL Server系列新版,SQL Server 2008 Internals目錄IDESQLServer
- Microsoft SQL Server 2008中SQL Server服務啟動故障問題ROSSQLServer
- SQL SERVER 2008的top增強SQLServer
- SQL Server 2008指定恢復模式SQLServer模式
- SQL Server 2008新特性稀疏列SQLServer
- SQL Server 2008 引入了“稀疏列”SQLServer
- SQL Server 2008稀疏列的使用SQLServer
- SQL Server 2008 建立非聚集索引SQLServer索引
- SQL Server 2008 MERGE語法SQLServer
- SQL Server 2008 查詢優化SQLServer優化
- SQL Server 2008恢復模式概述SQLServer模式
- SQL Server 2008 備份壓縮SQLServer
- SQL Server 2008 RTM釋出拉SQLServer
- 巧用JDBC連線SQL SERVER 2008JDBCSQLServer
- SQL Server 2008各版本區別SQLServer
- SQL Server 2008 新增功能 -- 複製SQLServer
- 初探SQL Server 2008 Change TrackingSQLServer
- SQL Server 2008香港釋出會SQLServer
- SQL Server 2008升級顧問SQLServer
- SQL Server 2008 化繭成蝶SQLServer
- Sql Server2008 格式化 Sql的 工具SQLServer