November 14, 2008 at 2:35 am
I wanted to drop a Primary key Constraint index(Composit) from a Large table . But It was taking time to drop that index. So I thought, To drop that index, we should first drop the related row from sysindexes and sysobjects table. After deleting the records from the sys tables ,I tried to drop it but it is giving error
'' Could not find the row in SysIndexes Table for table with ID............''
I tried to create the Index on that table but it is still giving error, ' Table already has primary key'
Even after restarting the server the same error is coming.
Even I ain't able to fetch the data from that table.
In Enterprize manager that table is no being displayed.
I don't want to restore the database but to recover that row in the Sysindexes table.
KPR
November 14, 2008 at 3:26 am
I hope this teaches you not to change systemtables anymore, especially when you don't really know what you're doing.
The only option you have is to restore the database. Just recreating the rows you've deleted won't work since the internal identifiers will not match up.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply