-
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
-
Primary key creation - strange message (SQL server7 - SP3) (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|