We have table with around 90 million rows and is partitioned on a column for example say A. There already exists a unique key. Now I would like to create a full text index on another column for example let us say B. Column B is not unique and hence unique key index can't be created here. I want to create full text index on Column B. My question is as follows
1) Is it possible to create full text index on column which is not unique.
2) If it is possible than what is my option to allow application to do advance search on this column.
We have SQL Server 2005 64 bit enterprise edition.