BlockingTimeout Property
Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The BlockingTimeout property specifies a timeout interval for resource requests that are blocked due to conflicting resource lock requests.
Syntax
object
.BlockingTimeout [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A long integer that specifies a number of milliseconds
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetBlockingTimeout(LPLONG pRetVal);
HRESULT SetBlockingTimeout(long NewValue);
Hinweise
For SQL Distributed Management Objects (SQL-DMO) applications, the default value for BlockingTimeout is 10,000 milliseconds (10 seconds).
The BlockingTimeout property determines the number of milliseconds waited when the SQL-DMO application needs sole access to a client resource. For the SQLServer object, the LoginTimeout and QueryTimeout properties control time-out behavior when an application request for a Microsoft SQL Server resource is made.
An attempt to set the BlockingTimeout property to a negative value returns the setting to the default 10 seconds (10,000).