Datamaker: Issue with queries when doing data selects, inserts, etc.

book

Article ID: 17032

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Our temptable seems to be growing and is not emptying out.  Our DBAs can increase the temptable, but want to know if it can be managed within the tool.



Is there a method, SQL statement, or any kind of procedure to reduce or release "stale" data in the temptable in SQL?

Environment

Release: TDMTDD99000-4.4-Test Data Manager-for Test Data on Demand
Component:

Resolution

The temp database is used by the SQL Server query optimizer. We do not interact directly with this database. Therefore, we do not have a method to be able to release space.