ClearTickets

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)