Index cannot be chosen as full-text search index.

• Anton Bach

  SSC Enthusiast

  Points: 195

  More actions

  March 17, 2010 at 6:31 pm

  #156792

  Hi all,

  I have a table which already has a full-text index, and is working fine. Today I tried to add 2 new fields to the table using Management Studio. The fields are date fields and are un-related to the full-text search. When I tried to save the changes I get the following error:

  'tblUserProfile' table

  - Unable to modify table.

  Index: PK_tblUserProfile cannot be chosen as full-text search index.

  I have added several other fields to this table since the full-text index was created, with no problems, so I'm wondering why this error is happening now?

  Database version is 9.0.3080.

  Thanks for any help.

  ROSCO

• Anton Bach

  SSC Enthusiast

  Points: 195

  More actions

  March 17, 2010 at 7:20 pm

  #1135671

  Note: Doing it manually with an ALTER TABLE worked without error.

  ROSCO