Check Database Integrity

• hibp

  SSC Rookie

  Points: 41

  More actions

  December 23, 2008 at 9:08 am

  #197780

  check database integrity to generate error from the Maintenance Plans AND for execute T-SQL works well. The error is:

  "the package execution returned DTSER_FAILURE (1)"

  With any database.

  Thank you

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  December 23, 2008 at 9:21 am

  #916856

  Enable logging on the Maintenance plan job step in SQL Agent and log to a file. Then provide the contents from the log file in this post.

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]