Removing Unused Counterparties

Here are some steps a database administrator may follow to eliminate any unused counterparties in your Insolvency database. these are Counterparties that do not have any links to transactions, creditor claims or any other entities.

The process is:

1. Back up your database

2. In the SQL Management Studio, select the Insol2 database in a new query window

​

3. Execute the following stored procedure

EXEC gensp_CounterpartyDeleteUnused

You may like to execute this stored procedure at the end of the day when users are unlikely to be in the software.