Complete factory reset

To set Litmus Production Record Database back to an empty state, an option for a factory reset exists.

User can do this either by using applications such as:

This can also be used for building custom solutions based on applications which allow for an ODBC connection such as:

Execute Stored Procedure PROREC_Misc_Factory_Reset

This will completely erase all configurations and date.

To factory reset Litmus Production Record Database, execute PROREC_Misc_Factory_Rese using the T-SQL EXEC or EXECUTE keyword. Below is an example using T-SQL in SQL Server Management Studio:

The stored procedure will reset the entire database to a state as if it was newly installed.

The result can be read back from the log table PROREC_Misc_Log.

Below is an example using T-SQL in SQL Server Management Studio:

With the result returned