SQL Server 2012 安装或添加全文搜索

2022-01-03 00:00:00 full-text-search sql-server sql-server-2012

我在 SQL Server 2012 中工作，并且想使用 CONTAINS() 函数，但似乎我需要启用全文搜索才能使用它.如何在现有的 SQL Server 2012 安装中启用/安装此功能?我需要的是步骤，因为我还没有找到解决这个问题的步骤.

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.

推荐答案

您可以通过在程序和功能"中更改 SQL Server 程序，将全文添加到现有实例中.请按照以下步骤操作.您可能需要原始磁盘或 ISO 才能完成安装.(根据 HotN 的评论:如果您有 SQL Server Express，请确保它是 SQL Server Express With Advanced Services.)

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.)

路线:

  1. 打开程序和功能控制面板.
  2. 选择 Microsoft SQL Server 2012 并单击更改.
  3. 当提示添加/修复/删除时，选择添加.
  4. 继续执行向导，直到出现功能选择"屏幕.然后选择全文搜索.

  1. 在安装类型"屏幕上，选择适当的 SQL Server 实例.

  1. On the Installation Type screen, select the appropriate SQL Server instance.

继续完成向导的其余部分.

Advance through the rest of the wizard.

来源(附截图):http://www.techrepublic.com/blog/networking/adding-sql-full-text-search-to-an-existing-sql-server/5546

相关文章