SQL error 2501: help

• wenhong

  Mr or Mrs. 500

  Points: 534

  More actions

  August 27, 2003 at 8:22 am

  #58724

  I run a scheduled intergrity check job on our production database (SQL 7.0 sp3a, Win2K sp4) and got an error message in job histry:

  Could not find table named '(Object ID 258647932)'. Check sysobjects. [SQLSTATE 42S02] (Error 2501) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 2528). The step failed.

  if I run DBCC CHECKDB ('mydb') again, still failed but with different Object ID.

  If I run same command on Web reporting server which use production server's backup file to restore and have same database name, DBCC CHECKDB ('mydb') is successful.

  Can anyone tell me what is wrong with error message, if I run a query on 'mydb': select * from sysobjects where ID=258647932, came out nothing.

• philcart

  SSC-Forever

  Points: 47794

  More actions

  August 27, 2003 at 6:26 pm

  #471724

  Have a look at the following KB article,

  http://support.microsoft.com/default.aspx?scid=kb;en-us;288745

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface