Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Database-connection-timeout: Stsadm property (Windows SharePoint Services)

SharePoint 2007

Updated: December 20, 2007

Applies To: Windows SharePoint Services 3.0

Updated: 2007-12-20

Description

Retrieves an open connection or sets a connection to a Microsoft SQL Server database.

Syntax

stsadm -o setproperty

   -propertyname database-connection-timeout

   -propertyvalue <A valid time, in seconds>

   [-url] <http://server_name>

The syntax for the getproperty operation is:

stsadm -o getproperty

   propertyname database-connection-timeout

   [-url] <http://server_name>

NoteNote:

You can substitute -pn for -propertyname and -pv for -propertyvalue.

Values

The following table shows possible values.

Name Value

propertyname

Gets or sets the name of the property.

propertyvalue

A valid time, in seconds. The default value is 15 seconds.

A value of zero indicates no limit, and should be avoided because an attempt to execute this value will wait indefinitely.

url

Typically, a path to the URL of the Web application, in the form http://server_name.

Examples

To set the timeout value to a connection to 45 seconds, use the following syntax:

stsadm -o setproperty -pn database-connection-timeout -pv 45

To view the current setting of the database-connection-timeout property, use the following syntax:

stsadm -o getproperty -pn database-connection-timeout

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.