Stored Procedure Accelerator Guide for Microsoft SQL Server

9.9.2
- 9.9.3
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Stored Procedure Accelerator Maintenance

Remove tables in the temporary database or use the cleanup script template to create a job that drops the temporary objects that the accelerator creates in the Microsoft SQL Server TempDb database as part of the masking process.

To mask stored procedures, Dynamic Data Masking dynamically creates tables in the Microsoft SQL Server TempDb database. After the Rule Engine applies masking rules to the SQL statement, it sends the request to the tables in the TempDb database.

When you set up the accelerator, you can create the CLEANUP_TEMP_OBJECTS procedure and schedule the procedure job to drop the tables. If you do not create the procedure, you must periodically manually drop the tables in the Microsoft SQL Server TempDb database.

Introduction to the Stored Procedure Accelerator for Microsoft SQL Server

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal