Error 7653 when executing CREATE FULLTEXT INDEX

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DC - 14 May 2007 17:50 GMT

Hi,

I receive Message 7653 when I try this:

CREATE FULLTEXT INDEX
ON Products
(Name LANGUAGE 0x0)
KEY INDEX ID
WITH CHANGE_TRACKING AUTO;

The message states that ID is an invalid column because it must not
allow nulls, be unique and the like, but ID is really a simple int
primary clustered key and meets all those requirements. I cannot
recreate the table since it is in production, does someone know what
to to?

Regards
DC

Reply to this Message

DC - 15 May 2007 08:02 GMT

Of course the documentation clearly states that the name of the index
is required, not the name of the indexed column (and that is what "ID"
was).

So in my example, this worked:

CREATE FULLTEXT INDEX ON Products (Name LANGUAGE 0x0)
KEY INDEX PK_Products
WITH CHANGE_TRACKING AUTO;

> Hi,
>
[quoted text clipped - 14 lines]
> Regards
> DC

Reply to this Message