Database-connection-timeout: Stsadm property (Windows SharePoint Services)
Applies To: Windows SharePoint Services 3.0
Topic Last Modified: 2007-12-17
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\]** \<https://server\_name\>
The syntax for the getproperty operation is:
stsadm -o getproperty
propertyname database-connection-timeout
**\[-url\]** \<https://server\_name\>
Note
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