Board index SQL SERVER

Can not get any search result using full text search in SQL Server 2005 Express.

Can not get any search result using full text search in SQL Server 2005 Express.

Post by dinesh.shr » Tue, 30 Oct 2007 19:42:11


Hi I am using SQL Server 2005 Express for full text search. I have
created catalouge and fultext index on the database and table. I
checked all the properties of the full text index using the queries.
select * from sys.fulltext_indexes

and everything seems to be fine.

But I am not getting any query results when I perform the following
query

select * from itemtags where contains(tags,'"clickz"')

Please someone help me!!!
 
 
 
Top

1. Surely a bug in SQL Server 2005 Full Text Search (FTS) or Backup?

2. Full Text Search on Patterns in SQL Server 2005

Can the full text search in SQL Server 2005 handle cases like a wildcard in
the middle of a word?

--
Will

3. Error Installing Full Text Search to Existing SQL Server 2005

4. Surely a bug in SQL Server 2005 Full Text Search (FTS) or Back

5. Near keyword in Full Text Search SQL Server 2005

6. SQL Server 2005 with advanced services and full text search

7. Sql Server 2005 (Yukon) Full Text Search

8. Near keyword in Full Text Search SQL server 2005

9. Error Installing Full Text Search to Existing SQL Server 2005 Stan

10. Full text search and SQL Server Express

11. Full-text search, user instance, and SQL Server Express

12. Sites on SPS server do not have a search bar, WSS full text search cannot enable

13. Installing MS SQL 2005 express with MS SQL express 2005 Full stand

14. Carrying out a full-text search, but without the full-text search...

15. Using SMO for SQL Server 2008 Express AND SQL Server 2005 Express

All times are UTC
Board index