2012年3月11日星期日

Full Text Index Error

I am trying to define Full Text Indexing on the following table:
CREATE TABLE [dbo].[CCINFORMATION] (
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AWID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Status] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Steffdt] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CostCtr] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CostCtrEffdt] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PrevCostCtr] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MgrName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MgrAWID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MgrEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MgrTitle] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

But it keeps giving me the following error when I try to run the wizard:
The selected table has no
unique single column index on a column that does not allow NULLS.

Database: CCReport

Table: [dbo].[CCINFORMATION]

Both the AWID field, and the ID field (which I added after first receiving this message), are NOT NULL...what am I doing wrong here?I have a solution to this. The syntaxes which you have given..I have copied the same and run. It did give me the error which you have mentioned.

Go to table design and create a Primakry Key. I have set the ID column as the primary key. Now it creates the Full-Text Index.

Thanks & Regards,
Dipayan Sarkar
(dipayan@.covisible.com)
[CoVisible Solutions - a Knowledge Management Software Company)

没有评论:

发表评论