Modify Application Configuration Items

use cases litmus production record database allows users to modify certain application configuration items used by the application to review which configuration items can be modified, please review docid\ evlxiglsvxjkjcqsgf2pp user can modify configuration items either by using applications such as microsoft sql server management studio mssql cli or 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 update app config input variables 155,141,239,219,133,114 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type how to use to modify one or several configuration item(s), call the stored procedure prorec misc update app config using the t sql exec or execute keyword and provide the input variables below is an example using t sql in sql server management studio example of modifying one configuration item execute \[le productionrecord] \[dbo] \[prorec misc update app config] @appconfigitems = n'days to keep log', @appconfigitemvalues = n'2'; example of modifying several configuration items execute \[le productionrecord] \[dbo] \[prorec misc update app config] @appconfigitems = n'days to keep prorec,days to keep tag', @appconfigitemvalues = n'100,75'; result the function returns a table with the new value example of modifying one configuration item example of modifying several configuration items