Installations of EPX that use SQL Server as the repository will have several tables used to manage sequences that will grow over time. A stored procedure is provided called sequence_cleanup()" that can be executed to purge unnecessary rows from these tables. It is suggested that this stored procedure be executed on a periodic basis to ensure the tables do not grow unnecessarily large.
To maintain tables for SQL Server:
Open the Query Analyzer Tool that can access the SQL Server EPX Repository.
Log in using the EPX user name and password (or another ID or password that has the same access rights to the database).
Inside the Query Analyzer Tool, select the database you want to maintain in the Databasedropdown list.
Type in the command exec SEQUENCE_CLEAN_UP; and run the execute command.
Note: The result can be verified at the Messages tab underneath the Query box.