SQL FUll Text Error
From: satyagng (satyagng_at_discussions.microsoft.com)
Date: 01/27/05
- Next message: Mike Mertes: "ADODB vs. ADOX"
- Previous message: Bob: "How to support NULLS in XSD"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Mike Mertes: "ADODB vs. ADOX"
- Previous message: Bob: "How to support NULLS in XSD"
- Messages sorted by: [ date ] [ thread ]