Error 2727 and Error 2768

• GF

  Hall of Fame

  Points: 3774

  More actions

  May 13, 2007 at 10:54 pm

  #68625

  Hi All,

  This pertains to SQL2000 sp4

  I have SQL Agent jobs that have been running for years with no problems.

  All of a sudden I am getting errors. Error 2727 and Error 2768

  Error 2727 is "cannot find index hind_c_18862788125_3A_1A"

  Error 2728 is "Statistics for index IX_accounts_account_id_company_id"

  I dropped the index IX_accounts_account_id_company_id and recreated it but this did not solve the problem.

  I have tried to find hind_c_18862788125_3A_1A index but I cannot.

  The scary part for me is this is suddenly happening and it is occurring on more than one table.

  How can I fix this and is it a precursor to things to come?

   

  Thanks

   

  Gary

• Johan Bijnens

  SSC Guru

  Points: 135377

  More actions

  May 14, 2007 at 12:01 am

  #706107

  for this kind of errors, I'd always start with launching

  dbcc checdb ( 'database_name' )   WITH ALL_ERRORMSGS 

  and work from there on.

  (check BOL)

   

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• dba-don

  SSC Enthusiast

  Points: 120

  More actions

  May 14, 2007 at 2:54 am

  #706144

  Try run the UPDATE STATISTICS command as the reference types mentioned above relate to the stats built by the query optimizer on the indexes as query hints.

   

  Thus if the index was corrupted or altered and the stats have not updated this may cause the above mentioned problems..

   

  Hope this helps