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

[Mitesh]

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

[Puran Baru]

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