Full Text Catalog, compound key problem

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Full Text Catalog, compound key problem

Author

Topic

BigMeat
Yak Posting Veteran

56 Posts

Posted - 2007-12-19 : 15:21:04

Hi

I have a sql 2000 db which has a table that has a compound key, the problem is that I would like to create a Full Text Catalog for this table. However I noticed that i need a single primary key... but I dont have one.

I created another field on my table called "ftcID" as an int with identity set to Yes

However when I try and create a catalog it doesnt detect that this field is unique.

Does my unique field have to be a Primary Key, I cant remove the compound primary key as it will break my application.

Any help would be much appreciated

Many thanks in advance

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-19 : 15:30:56

Did you create unique constraints on ftcID?