full text search on views in express edition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db - 27 Mar 2008 17:49 GMT

Hi

Is full text indexing possible on views in SQL server express edition with
advanced services? If Yes then how to do it on a view where I want to do
full text search on five different columns?

Thanks

Signature

ontario, canada

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 27 Mar 2008 17:51 GMT

I am fairly certain that you can only have one full-text index per table or
*indexed* view. So, if your view is not indexed, you will need to create
your FT index on the underlying table(s).

> Hi
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

db - 27 Mar 2008 21:30 GMT

I created a full text index on the base table. Will use base table(L.B22) and
not view using syntex:

create fulltext index on L.B22
key index ui_fts22 on B221_fulltextcatalog
with change_tracking AUTO

Now I want to

1. View details about full text index in my database/table.
2. When I created index I created it on one column. I want to use full text
search on multiple columns. Can I add more columns and if yes how.

Signature

ontario, canada

> I am fairly certain that you can only have one full-text index per table or
> *indexed* view. So, if your view is not indexed, you will need to create
[quoted text clipped - 7 lines]
> >
> > Thanks

Reply to this Message