如何打开SQL Server 2005上的FULLTEXT模式 [英] How to turn on the FULLTEXT mode on SQL Server 2005

问题描述

首先，我想创建目录：

  USE [AspDotNetStorefront] 
 GO 
 EXEC sp_fulltext_database'enable'
 GO 
 CREATE FULLTEXT CATALOG searchcatalog 
 GO 
  

但这并不奏效，结果如下：

 消息7609，级别17，状态100，行1 
全文搜索未安装，或全文组件不能被加载。 
  

我在Windows XP，SQL Server Express 9.0.4053上运行，我有SQL Server Management Studio Express（9.0）。

解决方案

全文搜索仅适用于SQL Express高级版本，请参阅 SQL Server版本支持的功能。从 Microsoft SQL Server获取2005 2005 Express Edition with Advanced Services ，2008，带有高级服务的Microsoft SQL Server 2008 Express

I'm currently trying to create FULLTEXT indexes into my database (Microsoft SQL Server 2005).

First I want to create the catalog:

USE [AspDotNetStorefront]
GO
EXEC sp_fulltext_database 'enable'
GO
CREATE FULLTEXT CATALOG searchcatalog 
GO

But that doesn't work, the result is this:

Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.

I'm running on Windows XP, SQL Server Express 9.0.4053 and I have SQL Server Management Studio Express (9.0).

解决方案

Full-Text search is only available in the SQL Express Advanced versions, see Features Supported by the Editions of SQL Server. Get 2005 from Microsoft SQL Server 2005 Express Edition with Advanced Services, 2008 from Microsoft SQL Server 2008 Express with Advanced Services

这篇关于如何打开SQL Server 2005上的FULLTEXT模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！