Tuesday, March 20, 2012

Problem with FTS

I am trying to setup Full Text Search Service on my SQL 2000 Server Database
The problem I am having is that the "NEXT" button is not setting to enable when I select all IMAGE column to be populate
Why is it behaving like this ? am I missing something? I attach the Table structure & FTS Image link
Please help me
This is a sample image here


Why is theNEXT button disabled
http://80.42.24.114/you/callbackajax/1.gif
This is also my Table structure
http://80.42.24.114/you/callbackajax/2.gif

The text below is from the BOL(books online) about the extra column requirement to use Image column in Full Text index.
Run a search for Full Text image column in the BOL (bboks online) for more info. Hope this helps.
(Thus, when you set up full-text indexing on an image column in a table, you must create a separate column to hold information about the document. This type column can be of any character-based data type and contains the document file extension, such as doc for a Microsoft Word document. If the type column is NULL, the full-text service will assume the document is a text file.

In the Full-Text Indexing Wizard, if you select an image column for indexing, you must also specify a Binding column to hold the document type.


The sp_fulltext_column stored procedure also accepts an argument for the column to contain the document types.


The sp_help_fulltext_columns stored procedure also returns column name and column id of the document type column. )

No comments:

Post a Comment