Web Development

Ask something
Discussion Locked

Error in Sql Server

0 helpful
5 replies

by m_amin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

While retrieving some data from a table SQL Server returned an error message showing:

S1000: [Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to fetch logical page 2166 in database 'accpro2001-02' belongs to object '412527991', not to object 'table name'

What happened there?

5 replies

by jmiller1

Try running:
DBCC CHECKDB
or
DBCC CHECKTABLE('tablename')

It looks like the page linkage got messed up in the system tables. The above commands should correct this.

This discussion is closed to new replies.