Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tommccann
Starting Member
5 Posts |
 Posted - 2011-12-12 : 18:09:38
|
| I want to try out the full text search functions. Using Adventureworks, I created a full text catalogue called ftsDefaultCatalog. That worked ok.However, when I try to create a full text index on the Production.ProductReview table using this code:CREATE FULLTEXT INDEX ON production.ProductReview (Comments)KEY INDEX [ProductReviewID]ON ftsDefaultCatalogI get this error message:Msg 7653, Level 16, State 1, Line 1'ProductReviewID' 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, does not have a filter, and has maximum size of 900 bytes. Choose another index for the full-text key.When I look at the column defintion, ProductReviewID is a PK. I'm not sure why SQL is giving me this error message. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-13 : 01:08:41
|
| is ProductReviewID an identity column?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tommccann
Starting Member
5 Posts |
Posted - 2011-12-13 : 02:28:26
|
No. It's not an identity column. However, the fact that it is a PK means that it is unique and non-nullable and that is what is required by the CREATE INDEX operation.quote:
Originally posted by visakh16
is ProductReviewID an identity column?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
brian147
Starting Member
10 Posts |
Posted - 2011-12-18 : 03:10:53
|
| KEY INDEX must be the index name - not the column name. |
|
|
|
|
|
|
|
|
Cannot create full text index