Using Code to Write Setting Values for Microsoft SQL Server

Contents

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:

1. Open the Query Analyzer/SSMS and connect as privuser.
2. 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'