Can't create fulltextcatalogs

30 Jun 2006 6:02 AM

Lasse Edsvik

Hello

I have a strange problem. I'm trying to create some fulltext catalogs using
management studio 2005, and it works great. But on one table I have a
composite key (?) PRIMARY KEY(A,B), and when I rightclick table and pick
create new fulltext catalog and press next it says that no indexes are
avalible :(

Howto solve this? Mess with the table and set just A or B as primary key?
doesn't feel right to do that.

/Lasse

30 Jun 2006 1:55 PM

Hilary Cotter

full text indexes can't be created on composite keys. Create a unique index
on another column or add an identity column and create a unique index on
that column.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Show quote

"Lasse Edsvik" <lasse@nospam.com> wrote in message
news:e%23O6ppAnGHA.964@TK2MSFTNGP05.phx.gbl...
> Hello
>
> I have a strange problem. I'm trying to create some fulltext catalogs
> using
> management studio 2005, and it works great. But on one table I have a
> composite key (?) PRIMARY KEY(A,B), and when I rightclick table and pick
> create new fulltext catalog and press next it says that no indexes are
> avalible :(
>
> Howto solve this? Mess with the table and set just A or B as primary key?
> doesn't feel right to do that.
>
> /Lasse
>
>