开发者

Full text index issue

开发者 https://www.devze.com 2023-03-15 22:20 出处:网络
I am creating a full text search index like this: CREATE FULLTEXT INDEX ON [dbo].[vwBusinessSearch] ([Address] LANGUAGE 1033,[City] LANGUAGE 1033,[State] LANGUAGE 1033,[Registration No] LANGUAGE 1033

I am creating a full text search index like this:

CREATE FULLTEXT INDEX ON [dbo].[vwBusinessSearch] ([Address] LANGUAGE 1033,[City] LANGUAGE 1033,[State] LANGUAGE 1033,[Registration No] LANGUAGE 1033,[Phone] LANGUAGE 1033,[Contact Phone] LANGUAGE 1033,[Contact Fax] LANGUAGE 1033,[Fax] LANGUAGE 1033,[Business Name] LANGUAGE 1033) KEY INDEX [IX_Registry_ID_Business] ON [ft_cat_CreditRegistry_Nigeria] WITH CHANGE_TRACKING OFF
GO

ALTER FULLTEXT INDEX ON [dbo].[vwBusinessSearch] ENABLE

GO

but getting following error:

SQL03006: Full-text Index contains an unresolved reference to an object. Either the object does not exist开发者_运维问答 or the reference is ambiguous because it could refer to any of the following objects: 

If I try to create an index like this:

CREATE UNIQUE CLUSTERED INDEX [IX_Registry_ID_Business] ON [dbo].[vwBusinessSearch] ([Registry ID]) ON [PRIMARY]
GO

I get following:

SQL04127: The table or view ([dbo].[vwBusinessSearch]) has more than one clustered index.

Please suggest solution to this.

Thanks

0

精彩评论

暂无评论...
验证码 换一张
取 消