Using Code to Write Setting Values with Microsoft SQL Server

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:

  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'

Related Topics

Writing Setting Values

Using Code to Write Setting Values with Oracle



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, September 30, 2016