Database-command-timeout: Stsadm property (Windows SharePoint Services)
Applies To: Windows SharePoint Services 3.0
Topic Last Modified: 2007-12-17
Description
Retrieves or sets the wait time before terminating the attempt to execute a command and generating an error.
Syntax
stsadm -o setproperty
-propertyname database-command-timeout
-propertyvalue <A valid time, in seconds>
**\[-url\]** \<https://server\_name\>
The syntax for the getproperty operation is:
stsadm -o getproperty
propertyname database-command-timeout
**\[-url\]** \<https://server\_name\>
Note
You can substitute -pn for -propertyname and -pv for -propertyvalue.
Property values
The following table shows possible values.
| Name | Value |
|---|---|
propertyname |
Gets or sets the name of the property. |
propertyvalue |
A valid time. The default value is 30 seconds. A value of zero indications 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. |
Remarks
This property is the cumulative time-out for all network reads during command execution or processing of the results. A time-out can still occur after the first row of results is returned, and does not include user processing time, only network read time.
Examples
To set the timeout value to 45 seconds, use the following syntax:
stsadm -o setproperty -pn database-command-timeout -pv 45
To view the current setting of the database-command-timeout property, use the following syntax:
stsadm -o getproperty -pn database-command-timeout