SqlServer 2008 安装全文索引

在确认msftesql.exe 安装在 C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\ 后

1) 运行如下命令

sc.exe create msftesql binPath= "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\msftesql.exe -s:MSSQL10.MSSQLSERVER -f:MSSQLSERVER" DisplayName= "SQL Server FullText Search (MSSQLSERVER)"

 

2) 到注册表中，修改键值， 注意用括号""将路径引起来

[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\msftesql]

"ImagePath"

例如， 之前:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\msftesql.exe -s:MSSQL10.MSSQLSERVER -f:MSSQLSERVER

改成:

"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\msftesql.exe" -s:MSSQL10.MSSQLSERVER -f:MSSQLSERVER