DBCC Check Integrity Maintenance plan failed

• Rem70Rem

  SSCertifiable

  Points: 6166

  More actions

  October 6, 2008 at 8:55 am

  #194385

  Hi,

  I am trying to create a task dong a DBCC via the maintenance plan. When I run manually this command, the DBCC run perfectly "DBCC CHECKDB WITH NO_INFOMSGS". But when it executed via the a Maintenance plan it's failed.

  I found this KB "support.microsoft.com/kb/934459". It the KB it is saying This problem occurs in SQL Server 2005 builds 3042 through 3053 and in SQL Server 2005 builds 3150 through 3158. I am currently running with version 9.00.3282.00, so should be OK.

  Even if my build is higher, should I apply this KB?

  Thanks

• Rem70Rem

  SSCertifiable

  Points: 6166

  More actions

  October 6, 2008 at 2:32 pm

  #881336

  I will be using a T-SQL Statement to run DBCCs.

  I am curious to see if the DBCC maintenance plan is working for someone.

  Thanks