Stored Procedure Accelerator Guide for Microsoft SQL Server

Stored Procedure Accelerator Guide for Microsoft SQL Server

Step 2. Create the Cleanup Procedure

Step 2. Create the Cleanup Procedure

To conserve space in the database, use the job creation template to create a Microsoft SQL Server job that runs periodically.
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. If you do not run the clean up procedure, you must manually drop the tables in the temporary TempDb database.

0 COMMENTS

We’d like to hear from you!