Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    18

    Question Unanswered: 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?
    -Doug Picanzi

  2. #2
    Join Date
    Oct 2003
    Location
    Pune, India
    Posts
    14
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •