CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Vahid Ghadiri
Vahid Ghadiri

Reputation: 4076

Create Fulltext index on a view

I am going to create a full text index on a view but the unique index combo box in full text indexing wizard is disabled and "A unique column must be defined on this table/view" message is displayed. although i created a composite unique index on that view.

Any clue would be much appreciated

Upvotes: 1

Views: 2622

Answers (1)

susan
susan

Reputation: 46

Full text indexes have a few restrictions, I wrote a quick blog post that shows the TSQL syntax so you can see if you an error message and listed the restrictions that may be causing you problems.

Upvotes: 2

Related Questions