Rebuild Statistics and Reindex General network error

• chasinglight

  SSC Rookie

  Points: 27

  More actions

  April 17, 2005 at 8:54 am

  #88719

  Hello: Once a week we run a job to rebuild statistics and re-index the entire database. Last week we migrated the drives from raid 5 to raid 10. Since then we have been getting an error on this job.

  The error is:

  ConnectionRead (recv()). [SQLSTATE 01000]

  Msg 11, Sev 16: General network error. Check your network documentation. [SQLSTATE 08S01]

  The steps we are running are:

  EXECUTE sp_updatestats

  EXECUTE sp_createstats

  DECLARE

  @table_name VARCHAR(255),

  @stmt VARCHAR(255)

  DECLARE replace_four CURSOR FOR

  SELECT [name] FROM sysobjects WHERE xtype = 'U'

  OPEN replace_four

  FETCH NEXT FROM replace_four INTO

  @table_name

  WHILE (@@fetch_status = 0)

  BEGIN

  DBCC DBREINDEX (@table_name)

  FETCH NEXT FROM replace_four INTO

  @table_name

  END

  CLOSE replace_four

  DEALLOCATE replace_four

  There are no errors in the server log and this message is in the output file of the T-Sql.

  Can anyone clue me in how I should debug this error?

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  April 18, 2005 at 2:17 pm

  #553272

  Have a look at http://www.windowsitpro.com/sqlserver/forums/messageview.cfm?catid=1666&threadid=131185