SQL Server Check Catalogue Action

[FinalBuilder Professional Edition]

The Check Catalogue action checks for consistency in and between system tables in the specified database.

This action checks that every data type in syscolumns has a matching entry in systypes and that every table and view in sysobjects has at least one column in syscolumns.

Connection & Security

SQL Server

Server

Specify the MS SQL Server to use. Clicking "View List" will attempt to locate any SQL Servers on the network.

Server instance

The name of the specific database instance to connect to on the supplied server.

Security

Use integrated security

Use Windows Authentication mode for login. This requires that the user running the FinalBuilder project has access to the SQL server and instance in question.

Username

The username to use for connecting to the SQL server.

Password

The password to use for connecting to the SQL server

Maintenance Options

Databases to perform maintenance on

Database name

The name of the specific database to perform the database operation on.

Databases in maintenance plan (name)

The name of the database maintenance plan to run.

Databases in maintenance plan (id)

The id of the database maintenance plan to run.

Reporting options

Report to file

The location and filename of where the database report should be written to.

HTML report

Specify if the database report should be in HTML format or not.

Send report to operator through SQL mail

The operator to send the generated report to through SQL mail.

Write history to msdb.dbo.sysdbmaintplan_history

Make entries in the msdb.dbo.sysdbmainplan_history table for the operations performed. Zero's will be used for the plan id if no plan was used for the process.