Complete factory reset

use cases 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 microsoft sql server management studio mssql cli this can also be used for building custom solutions based on applications which allow for an odbc connection such as excel c# net python method execute stored procedure prorec misc factory reset note this will completely erase all configurations and date how to use 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 execute \[le productionrecord] \[dbo] \[prorec misc factory reset]; result 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 select top (100) \[logid] ,\[logtype] ,\[logprocedure] ,\[logentry] ,\[logtime] from \[le productionrecord] \[dbo] \[prorec misc log] where \[logprocedure] = 'prorec misc factory reset' order by logid desc with the result returned