full text search on views in express edition

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
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
your FT index on the underlying table(s).
"db" <db@.discussions.microsoft.com> wrote in message
news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
> 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
> --
> ontario, canada
|||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.
ontario, canada
"Aaron Bertrand [SQL Server MVP]" wrote:

> 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).
>
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:70DFE058-91C8-4D1D-96A7-277113460FB3@.microsoft.com...
>
>

full text incremental population

Hi!
Is there any possibility to populate indexes for inserted rows only
(or not to updated rows)
Regards
Max
On Apr 4, 10:27 am, maxl...@.gmail.com wrote:
> Hi!
> Is there any possibility to populate indexes for inserted rows only
> (or not to updated rows)
> Regards
> Max
pls... if anyone has came up with same problem. share your knowledge

FTS Q - Proximate meaning of phrases

Hi
Is it possible to find records that contain the string "cyber-shot" when the value for search is "cybershot"?? (This is an example and I need a dynamic solution)
Thanks,
Inon.Probably (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_15_3rqg.asp).

-PatP|||Depends upon exactly what you want. Are you doing a fuzzy search, or do you want to find all the values that contain the same characters? Do the characters have to be in the same order? Do you just want to ignore non-alphanumeric characters?
You will have to give more details on the problem if you want more details on the answer.