Navigation:  Operational Maintenance > Managing SSP 7 >

Reset SSP

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)