Full Text Indexing

[tshad]

I cannot seem to get this to work.

I have the following table:

CREATE TABLE [dbo].[QADocs] (
[fullFileName] [varchar] (100) NULL ,
[fileNameLong] [varchar] (100) NULL ,
[fileNameShort] [varchar] (100) NULL ,
[fileExtension] [varchar] (10) NULL ,
[version] [varchar] (20) NULL ,
[document] [image] NULL ,
[recordNumber] [bigint] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (200) NULL ,
[documentType] [varchar] (20) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

I am indexing on document and trying to use fileExension as my file Type. I tried to use documentType, but got the same error as it was building the index (except the error said 'documentType' is specified more than once.

Column names in each table must be unique. Column name fileExtension in table 'dboQADocs is specified more than once.

It isn't in there more than once.

What am I doing wrong?

Thanks,

Tom.

 

[tshad]

Found the problem.

Not sure what was causing it. I just did a select/into to a temp file and then did a select/into back and it works fine now.

Real strange.

Tom.