shine,

[quoted text, click to view]

You cannot create or reference a full-text index for a view. You
must reference the base table directly. From Books Online:

"A full-text index must be defined on a base table; it cannot be
defined on a view, system table, or temporary table."

Linda

Dear All

I got a problem when i am implementing a view. I have
built a full text index in one table and tried to access it through a view.
When i try to select rows from the view, error message stated that the table
is not full text indexed.

For example,
create view test_view as
select article_text from article

in which the field "article_text" in table "article" is full text indexed.

Please give advice and thanks.

Shine