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 BlockingTimeoutis 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).

Applies To:

Application Object

SQLServer Object