I am trying to create a full-text index on a table in my SQL 2005 Standard database. I ran into 2 issues:
- I had to execute the sp_fulltext_database procedure to enable Full-Text Indexing. According to the docs I should not have had to do this as "all SQL 2005 databases are enabled for full-text indexing". No biggie (one would think)...
- After I create the table, a PK index and a unique index over the INTEGER ID column, I create the Full-Text catalog. So far so good. However, when I try to create the Full-Text index, I get the following error message: "Msg
7653, Level 16, State 1, Line 1 'IAK1_TR_TextFullText_1' is not a valid index to enforce a full-text search key. A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise
nonpersisted computed column, and has maximum size of 900 bytes. Choose another index for the full-text key."
I have tried both the PK index and the Unique index. Both indexes are created over a single column (ID) which is an INTEGER, NOT NULL. Both indexes appear to conform to all of the requirements for the KEY INDE but I canot
successfully create the Full Text Index.
View Complete Post