|
amodi
Yak Posting Veteran
Saudi Arabia
83 Posts |
 Posted - 09/11/2009 : 10:31:27
|
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. |
|
Sql Full Text Search
