无法在localdb v\11.0中创建索引目录 [英] Can't create an index catalog in localdb v\11.0

问题描述

SQL语句：

CREATE TABLE [dbo].[indexTable] (
    [mapId]   VARCHAR (50)  NOT NULL,
    [keyword] VARCHAR (900) NULL,
    PRIMARY KEY CLUSTERED ([mapId] ASC)
);

Go
CREATE FULLTEXT CATALOG FTSearch

我获得

创建[FTSearch] ...

SQL72014：.Net SqlClient数据提供程序：

Msg 9982，第16行，状态100，第1行

无法在用户实例中使用全文搜索。

Creating [FTSearch]...
SQL72014: .Net SqlClient Data Provider:
Msg 9982, Level 16, State 100, Line 1
Cannot use full-text search in user instance.

我使用与visual studio 2012一起安装的 localdb \v11.0 。

I am using localdb\v11.0 that is installed along with visual studio 2012.

推荐答案

localdb\v11.0 不支持全文索引。我安装了 MS SQL Server 2012 express与高级服务，它的工作方式像一个魅力。我不得不重新创建一个全新的数据库，虽然它不是真的很麻烦我，因为我只是复制粘贴所有的DDL语句从我以前的数据库。另外，我不得不使用'。\SQLEXPRESS'而不是'（LocalDb）\v11.0'

localdb\v11.0 does not support fulltext index. I installed MS SQL Server 2012 express with Advanced Services and it worked like a charm. I had to create an entirely new database again though it wasn't really much of a problem for me as i just copy pasted all the DDL statements from the my previous database. Also i had to use '.\SQLEXPRESS' instead of '(LocalDb)\v11.0' as the server name.

在安装过程中，如果要节省磁盘空间，则只安装搜索的全文和语义提取并保留所有其他功能未选中。

During installation if you want to save disk space then only install Full-Text and Semantic Extractions for Search and leave all the other features unchecked.

编辑：
您可以使用旧的数据库。将旧数据库文件复制到新位置，最好是 C：\Program Files\ Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA
并运行以下sql语句。

You can use your old databse. Copy the old database files to a new location preferably to something like C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA and run the following sql statement.

CREATE DATABASE databaseName 
    ON (FILENAME = 'C:\Program Files\Microsoft SQL
    Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\filename.mdf'), -- Main Data File .mdf
    (FILENAME = 'C:\Program Files\Microsoft SQL
    Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\filename_log.ldf') -- Log file .ldf

    FOR ATTACH 
GO 

这篇关于无法在localdb v\11.0中创建索引目录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！