BlockingTimeout Property
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The BlockingTimeout property specifies a timeout interval for resource requests that are blocked due to conflicting resource lock requests.
Syntaxe
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);
Notes
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).