Create as Clustered Index Error

[jarno]

Hi all,

I am getting an error message when I try to make an already existing, unique index, clustered. Could anyone tell me what the error message is refering to?

Error Message:

'Tracks' table
- Unable to create index 'PK_Tracks'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
[Microsoft][ODBC SQL Server Driver][SQL Server]Location: statisti.cpp:3222
Expression: cbStmtTxtLen/sizeof(WCHAR) <= cwchStmtTxtLen
SPID: 51
Process ID: 828

 

[markVII]

More details are needed: type of the column you are trying to create a clustered index on; what method are you using; does the column contains any NULLS (unique constraint would allow NULL, at least once)
Most important: do you have any rules bound to the column? It seems so.

 

[jarno]

Hi MarkVII,

Details as requested:

The column is of data type varchar.
I am using Enterprise Manager and trying to change the index through the design - properties window.
There are no nulls in this column.
There are relationships with six other tables, all bound to this column.
Enforce relationship for replication and Enforce relationship for INSERTs and UPDATEs are checked.

I have other databases with the same core design, some will allow the clustered index to be created, others display the same error.

SQL2000 SP3