ClearTickets: Difference between revisions
Jump to navigation
Jump to search
Created page with "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..." |
m 1 revision imported |
(No difference)
| |
Latest revision as of 21:44, 25 May 2020
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)