Unable to create index directory in localdb v \ 11.0

Question

SQL statement:

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

This is the error I get

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

I am using localdb\v11.0 , which is installed with visual studio 2012.

Answer 1

localdb\v11.0 does not support full-text index. I installed MS SQL Server 2012 express with Advanced Services , and it worked like a charm. I had to create a completely new database, although this was not a big problem for me, as I just copied all the DDL statements from the previous database. I also had to use '.\SQLEXPRESS' instead of '(LocalDb)\v11.0' as the server name.

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

EDIT: You can use your old databse. Copy the old database files to a new location, preferably 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