Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Sql Full Text Search		  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

amodi
Yak Posting Veteran

Saudi Arabia
83 Posts
Posted - 09/11/2009 :  10:31:27  Show Profile  Reply with Quote
Hello friends,

I created a catalog, unique index and full text index as follows

create fulltext catalog ISFullTextCatalogDetails

create unique index ui_PagesMaster on Pages_Master(PageId)

create fulltext index on Pages_Master(Page)
Key Index ui_PagesMaster on ISFullTextCatalogDetails
with CHANGE_TRACKING MANUAL

Note: In the following

create fulltext index on Pages_Master(Page)
Key Index ui_PagesMaster on ISFullTextCatalogDetails
with CHANGE_TRACKING MANUAL

Column "Page"(where i want to search data) in Pages_Master table is of type varchar(max)

Every thing works fine, but when i search the data like:

SELECT pageId,Page,fk_pagecode FROM Pages_Master
Where contains (Page, ' "Procedures" ')
It is displaying no data???

Thanks.

amodi
Yak Posting Veteran

Saudi Arabia
83 Posts
Posted - 09/12/2009 :  09:58:12  Show Profile  Reply with Quote

Hello friends,

I just change the column type( where i am doing data search) from varchar(max) to varchar(100)
and its working.

Does sql server FTS not support varchar(max)? or
Does sql server FTS have some limit on varchar() character? or
Do i need to change some setting of Sql Server 2005?

Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000