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 |
|
sparrow37
Posting Yak Master
148 Posts |
 Posted - 2011-06-29 : 01:47:36
|
| Hi all: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 OFFGOALTER FULLTEXT INDEX ON [dbo].[vwBusinessSearch] ENABLEGObut 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]GOI get following:SQL04127: The table or view ([dbo].[vwBusinessSearch]) has more than one clustered index.Please suggest solution to this.Thanks |
|
|
|
|
|
Full text index issue