[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.
Specify the MS SQL Server to use. Clicking "View List" will attempt to locate any SQL Servers on the network.
The name of the specific database instance to connect to on the supplied server.
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.
The username to use for connecting to the SQL server.
The password to use for connecting to the SQL server
The name of the specific database to perform the database operation on.
The name of the database maintenance plan to run.
The id of the database maintenance plan to run.
The location and filename of where the database report should be written to.
Specify if the database report should be in HTML format or not.
The operator to send the generated report to through SQL mail.
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.