Server: Msg 604, Level 21, State 5, Line 1

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

Server: Msg 604, Level 21, State 5, Line 1

Author

Topic

gunjansr83
Starting Member

21 Posts

Posted - 2008-09-15 : 08:07:50

I've got a problem that I've never seen before. I have an exsisting table in Database that SQL claims to not exist in sysobjects. But it does exist in sysobjects as a User Table:

quote:
--------------------------------------------------------------------------------
Server: Msg 604, Level 21, State 5, Line 1
Could not find row in sysobjects for object ID 277576027 in database 'ORGANISATIONS'. Run DBCC CHECKTABLE on sysobjects.

Connection Broken

Gunjan Singh Rathore

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-09-15 : 11:24:30

You're running SQL 2000?

Can you run the following please and post the results

DBCC CHECKDB('ORGANISATIONS') WITH NO_INFOMSGS
DBCC CHECKCATALOG ('ORGANISATIONS') WITH NO_INFOMSGS -- only necessary if you are running SQL 2000

What do you get if you run the following?

SELECT * from sysobjects WHERE id = 277576027

--
Gail Shaw
SQL Server MVP

gunjansr83
Starting Member

21 Posts

Posted - 2008-09-16 : 10:49:52

Garry,

ITs works thanks mate

Gunjan Singh Rathore

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources