Receive "PK_FIXLETRESULTS is not a Constraint" SQL Error
Why do I get the error "PK_FIXLETRESULTS' is not a constraint." ?
To resolve this issue, execute the following commands within SQL Query Analyzer after logging into the bfenterprise database as the sa user:
alter table FIXLETRESULTS add constraint PK_FIXLETRESULTS PRIMARY KEY NONCLUSTERED( ComputerID, SiteID, ID )
Note: These symptoms may also occur with the PK_QUESTIONRESULTS table, in which case you can execute the following SQL command:
alter table QUESTIONRESULTS add constraint PK_QUESTIONRESULTS PRIMARY KEY NONCLUSTERED( ComputerID, SiteID, ID )
Translate this page: