Online Documentation for SQL Administrator for SQL Server
Check database
Use the Check Database Integrity Task dialog to check the allocation and structural integrity of user and system tables, and indexes in the database.
Use the General tab to set common properties for the check database task. To set relationships between tasks use the Precedence constraints tab.
Name
Enter the check database task name.
Enabled
Check this option to enable task execution.
Connection
Specify which server connection should be used for task execution. You can choose among existing connections or create a new one.
Database(s)
Use the drop-down list to specify which databases will be checked during the task execution.
- All databases
Generate a maintenance plan that runs maintenance tasks against all Microsoft SQL Server databases except tempdb.
- All system databases
Generate a maintenance plan that runs maintenance tasks against each of the SQL Server system databases except tempdb. No maintenance tasks are run against user-created databases.
- All user databases
Generate a maintenance plan that runs maintenance tasks against all user-created databases. No maintenance tasks are run against the SQL Server system databases.
If you choose Select databases... item or click the ellipsis 
button then define databases using the Select databases dialog.
Include checking index integrity
Check the integrity of all index pages as well as table data pages.
See also:
