Primary key creation - strange message (SQL server7 - SP3)

Hello,

When I try to create a primary key for a table(alter table tablename add primary key( columnname)), I get a message
" SQL 1918. ( Index (key=2) is being rebuilt)."
Does any one have a clue, as to why do I get this. The primary key does get created ,but my application stops working, after getting this message.

Thanks,
Mitesh

Hi Mitesh,

Check to see that there is any other non clustered index on that table. If you are dropping and recreating a clustered index on a table, then all the non clustered indexes will be rebuilt.

Hope this helps.
Good Luck!!!
Puran


------------
Mitesh at 1/22/01 2:35:56 PM


Hello,

When I try to create a primary key for a table(alter table tablename add primary key( columnname)), I get a message
" SQL 1918. ( Index (key=2) is being rebuilt)."
Does any one have a clue, as to why do I get this. The primary key does get created ,but my application stops working, after getting this message.

Thanks,
Mitesh