SQL Server 2012安装或添加全文搜索 [英] SQL Server 2012 Install or add Full-text search
问题描述
我在SQL Server 2012中工作,并且想要使用CONTAINS()函数,但似乎我需要启用全文搜索才能使用它。如何在现有的SQL Server 2012安装中启用/安装此功能?我需要的是步骤,因为我还没有找到执行此步骤的步骤。
您可以通过更改程序和功能中的SQL Server程序将全文添加到现有实例。按照下面的步骤。您可能需要原始磁盘或ISO才能完成安装。
(根据HotN的评论:如果您有SQL Server Express,请确保它是SQL Server Express 使用高级服务。)
- 打开程序和功能控制面板。 >选择Microsoft SQL Server 2012并单击更改。
- 当提示您添加/修复/删除时,选择添加。
- 功能选择屏幕。然后选择全文搜索。
-
在安装类型屏幕上,选择适当的SQL Server实例。
。
I am working in SQL Server 2012, and would like to use the CONTAINS() function only it seems I need to have full-text search enabled for to be able to use it. How do I enable/install this feature to an existing SQL Server 2012 install? What I need are steps please as I am yet to find the steps on going about this.
You can add full text to an existing instance by changing the SQL Server program in Programs and Features. Follow the steps below. You might need the original disk or ISO for the installation to complete.
(Per HotN's comment: If you have SQL Server Express, make sure it is SQL Server Express With Advanced Services.)
- Open the Programs and Features control panel.
- Select Microsoft SQL Server 2012 and click Change.
- When prompted to Add/Repair/Remove, select Add.
- Advance through the wizard until the Feature Selection screen. Then select Full-Text Search.
On the Installation Type screen, select the appropriate SQL Server instance.
Advance through the rest of the wizard.
Source (with screenshots): http://www.techrepublic.com/blog/networking/adding-sql-full-text-search-to-an-existing-sql-server/5546
这篇关于SQL Server 2012安装或添加全文搜索的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!