Smtxwiki: 1 revision imported

2020-05-25T20:44:27Z

1 revision imported

← Older revision	Revision as of 22:44, 25 May 2020
(No difference)

Smtxwiki: 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..."

2016-12-19T10:39:26Z

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..."

New 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)

ClearTickets - Revision history

Smtxwiki: 1 revision imported

Smtxwiki: 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..."