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