Cannot use full-text search in user instance

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

SQL

I'm trying to implement a SELECT....WHERE CONTAINS(), I'm testing the query in sql server Management and function really good but when I try to attach database to a ASP.NET in Visual Studio 2010 and throw this error:

 Cannot use full-text search in user instance.

and the same code work well,when i not use attached database mdf file,and directly connect my application with sql server 2008 r2.....

i also install all "sqlserver 2008 r2 full text search" , instance from microsoft site..

so what can i do please help

Posted 30-Sep-14 7:45am

Arun kumar Gauttam

Updated 30-Sep-14 19:14pm

v3

Add a Solution

Comments

ZurdoDev 30-Sep-14 14:08pm

Googling the error should give you plenty of results.

Arun kumar Gauttam 30-Sep-14 14:39pm

but they not provide a proper solution,so i ask ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2014-09-30T13:35:00

Solution 1

It's simple really. You cannot use Full Text Search on a database that you're attaching in your SQL connection string.

Posted 30-Sep-14 13:35pm

Dave Kreskowiak

Comments

Arun kumar Gauttam 1-Oct-14 1:13am

so what can i do,if i made a desktop application..
and it is necessary for me that i attached database with my setup....
and full text search is also very impotent in my application

Dave Kreskowiak 1-Oct-14 7:59am

You add scripts to your installation that run on the server to create your database.

You also have to change the connection string in your application so that you're NOT attaching the database to the server in a user instance.

Arun kumar Gauttam 10-Oct-14 2:52am

sir,plz give me any link for this..
add scripts in my Appliation installation that run on the server to create my database..

Dave Kreskowiak 10-Oct-14 7:58am

https://www.google.com/?gws_rd=ssl#q=build+installer+with+database