November 14, 2008 at 1:58 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 9:15 am
Restore the database from a backup taken before you deleted from the system tables. There's no other way to put the row back.
By modifying the system tables you have severely corrupted your database. The system tables should never be manually changed. Especially if you don't know what the change will do.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply