SQL Server Update DB Statistics Action
[FinalBuilder Professional Edition]
The Update DB Statistics action updates information about the distribution of key values for one or more statistics groups (collections) in the specified database.
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.
Update Statistics Options
Update statistics options
Sample percentage
Specifies the sample_percent in the following SQL statement, which is run against all tables;
UPDATE STATISTICS table WITH SAMPLE sample_percent PERCENT;