Navigation:  Operational Maintenance > Managing tickets >

Clear Tickets

Previous pageReturn to chapter overviewNext page

In some situations, the SSP database needs to be flushed from any operational data. This can be helpful before a go-live to reset the SSP ticket numbering to 0.

Definitions of Roles, Forms and Process will not be affected by this flush, only submitted Forms and Processes will be.

The database script below should be run on a MS SQL Server environment for doing the reset:

Delete from Email
Delete from FormInstanceValue
Delete from FormInstance
Delete from Visit
Delete from ProcessInstance
DBCC checkident (processinstance, reseed, 0)