Add a stored procedure for extensions ETL reset

These steps show you how to create a stored procedure from SQL Server Management Studio. However, the markup described in Revisions Spec: Reset accomplishes this. The advantage of using the revision is that it repeatable. But, to illustrate what the revision accomplishes, this procedure is provided.

1. From Microsoft SQL Server Management Studio, connect to the Database Engine for your server. From File, click Connect Object Explorer. The Connect to Server screen appears.

   

2. From Server Type, select "Database Engine."
3. Select your server's name.
4. Enter the appropriate authentication information.

5. Click Connect. The server appears in the Object Explorer.

   

6. Expand the BBDW database node.

7. Expand the Programmability node.

   

8. Right-click Stored Procedures and click New Stored Procedure. A new query to create a procedure appears.

   

9. Change the template name defaults to the name for your stored procedure.

   

10. Within the CREATE PROCEDURE section, enter lines for table truncations and dropping indexes.

    

11. Run the query to create the stored procedure. From Query, click Execute.