The following code snippets demonstrate how the SETTINGS_WRITE_STRING procedure sets the value of the ExpiredSessionTimeout setting to 12 hours with Microsoft SQL Server.
To set the value of the ExpiredSessionTimeout setting to 12 hours:
- Open the Query Analyzer/SSMS and connect as privuser.
- Select the P6 EPPM database, then run the following statement (using 12 hours as an example):
exec SETTINGS_WRITE_STRING '12h','database.cleanup.Usession',
'ExpiredSessionTimeout'