Automated Build Studio Operations - SQL Category
The SQL category includes the following operations, which let
you run Structured Query Language (SQL) queries and scripts within
your macros:
| Operations |
Description |
| Back Up Database |
Backs up the specified Microsoft SQL Server database. |
| Check Database |
Checks the integrity of objects in the specified Microsoft SQL Server
database. |
| Clean Up Database |
Removes unused space from the specified Microsoft SQL Server database. |
| Execute DTSRun |
Executes the specified DTS package. |
| Execute Stored Procedure |
Executes the specified stored procedure from a particular Microsoft
SQL Server database which is accessed via OLE DB. |
| Execute SQL Script |
Runs an SQL script that accesses a Microsoft SQL Server instance. |
| Execute SQL Statement |
Executes an SQL query against the specified Microsoft SQL Server
database which is accessed via OLE DB. |
| Rebuild Indexes |
Rebuilds indexes on tables in the specified Microsoft SQL Server
database. |
| Restore Database |
Restores the specified Microsoft SQL Server database from the backup file. |
| Run SQL Best Practices Analyzer |
Uses Microsoft SQL Server Best Practices Analyzer to verify whether
common best practices are implemented in the specified Microsoft SQL
Server database. |
| Update Statistics |
Updates information about distribution of key values in the
specified Microsoft SQL Server database. |
|
