jumpstart0321
asked on
Syntax for createing a FULLTEXT CLUSTERED INDEX SQL 2005
Here's what I have:
CREATE CLUSTERED FULLTEXT INDEX ON Items ( ItemName Language 0X0 ) KEY INDEX ItemKey_Index ON MyItemsCatalog WITH CHANGE_TRACKING AUTO
What's wrong?
CREATE CLUSTERED FULLTEXT INDEX ON Items ( ItemName Language 0X0 ) KEY INDEX ItemKey_Index ON MyItemsCatalog WITH CHANGE_TRACKING AUTO
What's wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you cannot have a CLUSTERED FULLTEXT, it is either CLUSTERED or FULLTEXT