SQL FUll Text Error

From: satyagng (satyagng_at_discussions.microsoft.com)
Date: 01/27/05


Date: Thu, 27 Jan 2005 05:53:01 -0800

I am getting

"'PK_IRSAgency' is not a valid index to enforce a full-text search key. You
must specify a unique, non-nullable, single-column index." Error While
Executing

If((SELECT DATABASEPROPERTY('Test8872','IsFulltextEnabled')) = 0)
exec sp_fulltext_database 'enable'
go

sp_fulltext_catalog 'IRSAgency', 'create'
go

sp_fulltext_table 'IRSAgency', 'create', 'IRSAgency','PK_IRSAgency'
go

The Error is in

sp_fulltext_table 'IRSAgency', 'create', 'IRSAgency','PK_IRSAgency'
go

I can clearly under stand that it needs a unique column index instead of
'PK_IRSAgency'.

Since we need to have this in deployment script we need a static field to be
placed instead of 'PK_IrsAgency'.

Is there a possibility to find the unique column index ?

Regards,
Sathiya