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:
| Operation | 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. |