This response contains the references to the third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites;
therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from the Internet.
Jian Kang
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
kapilbharat
Member
54 Points
146 Posts
can not use a contains or free text predicte on table or indexed view
Mar 18, 2009 01:01 PM|LINK
good evenning all,
select
* from mytable where contains(description,'apartments')i m running this query but getting "error"
Can not use a Contains or FreeText predicate on table or indexed view 'mytable' because it is not full-text indexed.
Thanks all of u.
Jian Kang - ...
All-Star
33132 Points
2465 Posts
Re: can not use a contains or free text predicte on table or indexed view
Mar 20, 2009 02:08 AM|LINK
Hi,
To use full-text search, we need to set full-text index on the table first.
Please refer to the document below:
Full-Text Search (SQL Server)
http://msdn.microsoft.com/en-us/library/ms142571.aspx
Full-Text indexing files with Microsoft SQL Server
http://www.codeproject.com/KB/architecture/sqlfulltextindexing.aspx
FullText Search In SqlServer 2005
http://amitpatriwala.wordpress.com/2008/08/11/fulltext-search-in-sqlserver-2005/
This response contains the references to the third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
umarok
Member
6 Points
12 Posts
Re: can not use a contains or free text predicte on table or indexed view
Feb 14, 2012 08:48 PM|LINK
I know this is old but,
Rather than type it that way, why not use
select * from mytable where description like '%apartments%'