Double records in system table 'sysobjects'

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Double records in system table 'sysobjects'

Author

Topic

lw1990
Yak Posting Veteran

85 Posts

Posted - 2009-02-24 : 16:39:11

Hi,
I'm running a third party program in SQL Server2000, and find that there are 2 objects by the same name, means in system table 'sysobjects' there are 2 objects for the same table "LangPro.

LangPro 683253589 U 1 6 1610612736 0 0 0 2/23/2009 11:00:03 PM ....

LangPro 2144778748 U 1 6 1610612736 0 0 0 4/18/2008 11:00:12 PM ....

If I drop the table, the second record is still in the table.
How Can I delete the second object from table 'sysobjects'?

Thanks.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-24 : 17:00:06

Where is the result of?

DBCC CHECKDB (DBNAME) WITH NO_INFOMSGS, ALL_ERRORMSGS

lw1990
Yak Posting Veteran

85 Posts

Posted - 2009-02-24 : 17:13:23

quote:
Originally posted by sodeep

Where is the result of?

DBCC CHECKDB (DBNAME) WITH NO_INFOMSGS, ALL_ERRORMSGS

Here is the result:

Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysobjects' (ID 1). Missing or invalid key in index 'ncsysobjects' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2771:48) identified by (RID = (1:2771:48) id = 2128778691) has index values (name = 'Addresses' and uid = 1 and id = 2128778691).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysobjects' (ID 1). Missing or invalid key in index 'ncsysobjects' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2771:50) identified by (RID = (1:2771:50) id = 2144778748) has index values (name = 'LangPro' and uid = 1 and id = 2144778748).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysobjects' (ID 1). Missing or invalid key in index 'ncsysobjects2' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2771:48) identified by (RID = (1:2771:48) id = 2128778691) has index values (parent_obj = 0 and id = 2128778691).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'sysobjects' (ID 1). Missing or invalid key in index 'ncsysobjects2' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2771:50) identified by (RID = (1:2771:50) id = 2144778748) has index values (parent_obj = 0 and id = 2144778748).
Server: Msg 7965, Level 16, State 1, Line 1
Table error: Could not check object ID 2144778748, index ID 0 due to invalid allocation (IAM) page(s).
CHECKDB found 0 allocation errors and 4 consistency errors in table 'Addresses' (object ID 651253475).
CHECKDB found 0 allocation errors and 2 consistency errors in table 'Phones' (object ID 667253532).
CHECKDB found 2 allocation errors and 1 consistency errors in table 'LVL' (object ID 1013578649).
CHECKDB found 0 allocation errors and 2 consistency errors in table 'Addresses' (object ID 2128778691).
CHECKDB found 0 allocation errors and 1 consistency errors in table 'LangPro' (object ID 2144778748).
CHECKDB found 2 allocation errors and 55 consistency errors in database 'Addresses'.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources