无法在用户实例中使用全文搜索 [英] Cannot use full-text search in user instance

问题描述

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.

和相同的代码工作得很好，当我不使用附加的数据库mdf文件，并直接连接我的应用程序与sql server 2008 r2 .. ...



我还安装所有sqlserver 2008 r2全文搜索，来自微软网站的实例..



所以我该怎么办请帮助

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

推荐答案

真的很简单。您不能在SQL连接字符串中附加的数据库上使用全文搜索。

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

这篇关于无法在用户实例中使用全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！